| 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:  |
 
|
