Evaluation of an algebraic object is carried according to the order of precedence of the operators — those with higher precedence are executed first.
Operations with the same order of precedence are executed from left to right. From highest precedence to lowest, the order of precedence is:
Order | Operation |
|
|
1. | Unit attachment: |
1.1 | Parenthesized expressions from innermost to outermost |
1.2 | Power (^) from bottom to top (i.e. 1_m^2^3^4 = 1_m^24) |
1.3 | Multiplication (*) and Division (/) |
2. | Parenthesized expression from innermost to outermost |
3. | Functions that require arguments (i.e. SIN, LOG) |
4. | Factorial (!) |
5. | Power (^) from top to bottom (i.e. 2^2^3^4 = 2^(2^(3^4))) and Root (√, XROOT) |
6. | Negation |
7. | Addition (+) and Subtraction |
8. | Relational operators (==, ≠, <, >, ≤, ≥) |
9. | Logical operators AND and NOT |
10. | Logical operators OR and XOR |
11. | Left argument of “Where” () |
12. | Equal (=) |
|
|
Technical Reference