Microsoft Office Tutorials and References

In Depth Information

**Addition and Multiplication Example**

Figure 9.2.

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

parentheses:

=(20+30)*1.06

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.