Microsoft Office Tutorials and References
In Depth Information
Addition and Multiplication Example
Figure 9.2. The underline indicates that Excel does the multiplication first.
The underline indicates that Excel does the multiplication first.
Excel ’ s answer is $1.20 less than expected because the formula is not writ-
ten with the default order of operations in mind.
To force Excel to do the addition first, you need to enclose the addition in
Figure 9.3 shows the second step in the Evaluate Formula dialog for this
formula. The addition in parentheses is done first, and then 50 is multiplied
by 1.06 to get the correct answer of $53.