Condition builder operators
The Basic Ops section of the Condition Builder contains the operators shown in the following table:
| Operator | Description |
|---|---|
| ( | The left parenthesis is used with the right parenthesis to change the order in which operations in a formula are performed. |
| ) | The right parenthesis is used with the left parenthesis to change the order in which operations in a formula are performed. |
| - | A minus sign is used for subtraction. |
| + | A plus sign is used for addition. |
| * | A star is used for multiplication. |
| / | A slash is used for division. |
| < | A less-than evaluates to true if the expression to its left evaluates to less than the expression to its right. |
| > | A greater-than evaluates to true if the expression to its left evaluates to greater than the expression to its right. |
| <= | A less-than-or-equals evaluates to true if the expression to its left evaluates to less than or equal to the expression on its right. |
| >= | A greater-than-or-equals evaluates to true if the expression to its left evaluates to greater than or equal to the expression to its right. |
| == | A double equals sign is used for equals. It evaluates to true if the expressions on both sides of it evaluate to the same value. |
| != | Exclamation point equals is used for not-equals. It evaluates to true if the expressions on both sides of it evaluate to different values. |
| && | A double ampersand is used for logical AND. It evaluates to true if the expressions on both sides of it evaluate to true. |
| || | A double vertical bar is used for logical "or". It evaluates to true if the expressions on either or both sides of it evaluate to true. |