IF AND THEN ELSEIF AND THEN TRUE ELSE FALSE ENDIF parse error - what did I do wrong?

[MaryCann]

I also tried this one:  

This is using the Filter tool.  

Also - it sucks being a newby and learning all this stuff that everyone else thinks is easy!

[Luke_C]

Hi @MaryCann 

The filter tool evaluates things to be true or false. Your formula should just be something like:

([SERVICE ID] > 19 and [SERVICE ID] < 26)

OR

([SERVICE ID] > 119 and [SERVICE ID] < 225)

Your existing formula would work to add a new field to flag True/False if used in a formula tool. 

[IraWatt · Accepted solution]

Hey @MaryCann, Your bottom formula looks fine just the case is wrong on the first element, should be [SERVICE ID] (case in important)

[MaryCann]

Hi @IraWatt  - OMG!!!  Such an easy oversight.  THANK YOU!  

[IraWatt]

No worries glad it worked for you ! :)

[MaryCann]

ACH!  Next Parse Error!  Okay - what about this: 

[Luke_C]

Hi @MaryCann 

Assuming the data is set to be numeric, what you have should work:

[IraWatt]

@MaryCann that error is because its string data type. Add a select tool before it and set it to an integer: 

[Shifty]

Nice solve, @IraWatt 

[IraWatt]

Thankyou Mr @Shifty