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.
