Find whether a value is between two numbers

[JM39]

Hello

I imagine this is quite simple but I'm struggling to find the answer. Essentially I'm trying to find a 'between' function. So I want to say:

If row1.MY_COLUMN is between 500000 and 610000 then use that value, else 'something else'..

Tia for any help!

[Anonymous · Accepted solution]

row1.MYCOLUMN >=500000 && row1.MYCOLUMN <=610000 ? row1.MYCOLUMN : -1

This is an in-line IF. It says, "IF MYCOLUMN is greater than or equal to 500000 and MYCOLUMN is less than or equal to 610000, then use MYCOLUMN, else use -1".

[JM39]

Works perfectly, thank you! 🙂