Question

IF in Between two integers

Hello,

Does anyone know how to write an if statement that returns a text where the criteria is in between 2 integers?

For example in excel it will go as the following:

=IF(AND(pto_used>=0,pto_used<=15),“Good”,“No”)

Thank you!

Userlevel 1

Hello Mohamed!

This syntax works in a table calculation to test for an integer being between two integers and return text values:

if(${orders.count}>100 AND ${orders.count}<200,"yes","no")

This Worked !!! Thanks for the quick turnaround !!!

Sign up