Order of operator evaluation
Use parentheses to group operations. Expressions within parentheses are evaluated before performing other operations. For example:
(UnitPrice - Discount) * Tax
The expression UnitPrice - Discount is evaluated before the rest of the expression.
Some operators are evaluated before others according to standard rules of precedence. Operators are evaluated in the following order:
Precedence | Operators | Description |
---|---|---|
first | ( ) | Operations within parentheses |
second | + and - | unary plus and minus The sign indicates a positive or negative expression, for example: - quantity*rate |
third | =, <, >, <=, >=, != | comparative operators |
fourth | ^ | logical operator "exclusive or" |
fifth | & | logical operator "and" |
sixth | | | logical operator "or" |
seventh | * and / | multiplication and division |
eighth | + and - | addition and subtraction |
Operators of equal precedence are evaluated left to right.