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 |
= = | If 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.[1] |
OR | Logical OR linking operator for multiple value tests. Result is TRUE if either condition is TRUE. Otherwise the result is FALSE.[2] |
NOT | Logical NOT operator. Result is TRUE if condition is FALSE. Result is FALSE if condition is TRUE.[3] |