IF stantment crashes with endif

[filipjasz]

I am trying to make if statment in formula tool:

IF [CutoffTotalClaimAmount] < 2000 THEN '<2000'
elseif [CutoffTotalClaimAmount] < 5000 THEN '2000-5000'
else '>5000'

endif

but it is not working, anyone can tell me why? Everything seems to be ok untill I write 'endif'

[Emil_Kos · Accepted solution]

Hi @filipjasz,

The column that you are referring to isn't in the numeric format or the formula that you are writing isn't a string format.

I performed the test and it works for me: