IF Function

Hi All,

Greetings for the day.

I have used IF function as below..

IF [Per Person Expense] <='25' THEN 'Yes' ELSE 'No' ENDIF

However in the output I am getting result as No for an expense which is less than 25. Ideally this should be Yes as per the formula.

Attached is an example.

Please help.

Thank you.

Connectors

Accepted answers

This is your setup

I'm guessing that the data type for [Per Person Expense] is a string, which means that <> would work like a dictionary sort.

Try tonumber([Per person Expense]) <= 25

Thank you David for your reply.

When I prefix Tonumber it gives me error - Invalid type in operator <=.