|
 |
|||
| Order of
Operations When using formulas, functions, or equations Excel operators have an order of precedence. The following is a list from highest to lowest precedence. |
|||
| Operator | Description | Example | |
| : (colon) | reference operator | =SUM(D4:F4) | |
| , (comma) | reference operator | =SUM(D4,D5, F6) | |
| - | negation | =A1-A4 | |
| % | percent | 20% | |
| ^ | exponentiation | 5^2 | |
| * and / | multiplication and division | =(A1*A2)/A2 | |
| + and - | addition and subtraction | =A1+A2-A3 | |
| = < > <= >= | comparison (<> means not equal to) |
=A5>6 =D5=D7 =A1<=A8 |
|
example: 
|
|||
