Great than Less than Function

[iamthejedi]

I want to create a field called [Value range] based on a range value from the [ Cum.acq.value] field.

I'm getting an error. 

Parse Error at char (597); Malformed If Statement (Expression #1)

I'm not sure why though. I'd appreciate some help.

Here's my function code:

if ([ Cum.acq.value]>= 0 and [ Cum.acq.value]< 7500) then "<7.5k"

else if ([ Cum.acq.value]> 7500 and [ Cum.acq.value]< 50000) then "<50k"

else if ([ Cum.acq.value]> 50000 and [ Cum.acq.value]< 100000) then "<100k"

else if ([ Cum.acq.value]> 100000 and [ Cum.acq.value]< 500000) then "<500k"

else if ([ Cum.acq.value]> 500000 and [ Cum.acq.value]< 1000000) then "<1m"

else if ([ Cum.acq.value]> 1000000 and [ Cum.acq.value]< 5000000) then "<5m"

else if ([ Cum.acq.value]> 5000000 and [ Cum.acq.value]< 10000000) then "<10m"

else ">10m" endif

[Ladarthure · Accepted solution]

hi,

just remove the space between else and if it's elseif 🙂

[iamthejedi]

Thank you!!