Question

IF in Between two integers

  • 10 April 2018
  • 2 replies
  • 1559 views

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!


2 replies

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 !!!

Reply