Conditional operators build logical condition into calculations.
Operator | Description |
---|---|
IF | ELSE | ELSEIF | ENDIF | Tests conditions and calculates a formula based on the success or failure of the test. |
> | Data value is greater than. |
>= | Data value is greater than or equal to. |
< | Data value is less than. |
<= | Data value is less than or equal to. |
= = | Data value is equal to. |
< > or != | Data value is not equal to. |
AND | Logical AND linking operator for multiple value tests. Result is TRUE if both conditions are TRUE. Otherwise the result is FALSE.* |
OR | Logical OR linking operator for multiple value tests. Result is TRUE if either condition is TRUE. Otherwise the result is FALSE.* |
NOT | Logical NOT operator. Result is TRUE if condition is FALSE. Result is FALSE if condition is TRUE.* |
* The logical constants TRUE and FALSE are interpreted as 1 (TRUE) and 0 (FALSE) where appropriate.