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.