Operators
The following operators can be used throughout the system in Formulas.
Operator | Definition |
|---|---|
| * | multiply |
| / | divide |
| + | add |
| - | subtract |
== | equals |
!= | not equals |
>= | greater or equal to |
<= | less than or equal to |
> | greater than |
< | less than |
| ~= | contains |
!~= | does not contain |
Variable Formula fields use a slightly modified syntax and list of operators. For more information, see Variable Formula Fields.
Logical Operators
You can combine formula criteria using logical operators such as AND and OR. These are:
| Operator | Definition | Example |
|---|---|---|
| || | Or | ($priority == High || $priority == Low) |
| && | And | ($contract_amount >= 50000 && $approval_required == 'Yes') |
Order of Operations
Formula expressions are evaluated from left to right. Use parentheses to group terms and define the order of execution. For example, A && (B || C) will evaluate to true if A is true, and also B or C is true. In contrast, A && B || C will evaluate true if A and B are true, OR if C is true.