How to use if statement for greater and less than

1

I want to assign a value to a variable if an input is greater than and less than two numbers in a range. Appgyver doesn’t seem to allow >&< in the IF statement. What is the proper syntax for this in an appgyver formula?

3

>&&< or maybe even better: nested IFs should be the solution for you.

4

Use two if functions nested together.

BOOLEAN(IF(varA>varLowerLimit,IF(varA<varUpperLimit,“True”,"","")

1 Like