Order of Precedence
When there are several operators in a formula, the formula performs the operations in a specific order. The formula is parsed from left to right, according to a specific order for each operator or function in the formula. You can prioritize the order of operations by using parentheses in the formula.
If you combine several operators in a single formula, the operations are performed in a specific order. Unary operations precede binary operations. If a formula contains operators with the same precedence, the operators are evaluated from left to right. To change the order of evaluation, enclose the part of the formula to be calculated first in parentheses; this has the highest precedence. Where the order of precedence is the same for two operators, the formula is evaluated from left to right.
| Operator | Description |
|---|---|
| left to right | Direction |
| ( ) | Parentheses for grouping |
| - | Negate (in front of a value) |
| + | Plus (in front of a value) |
| % | Percent |
| ^ | Exponent |
| * and / | Multiply and divide |
| + and - | Addition and subtraction |
| & | Concatenate |
| =,<=, <, >=,>,<> | Compare |
Return to the list of Operators in a Formula.