Excel adheres to a strict order of operations when calculating formulas. Keep this order in mind when building formulas to ensure accurate results.
Here is the order in which Excel evaluates formula operators:
- Colon, space, comma;
- Negative numbers;
- Multiplication and division;
- Addition and subtraction; and
- Less than, less than or equal to, greater than, greater than or equal to, equal, not equal to.
When a formula includes operators from the same level (such as multiplication and division, which are both level 6), Excel evaluates them from left to right.
Applying this order, Excel calculates the equation =(B4+C4)/(B5+C5)*100 as follows: First adding cells B4 and C4, then adding B5 to C5, dividing the first sum by the second sum, and then multiplying the result by 100.