Microsoft Office Tutorials and References

In Depth Information

**Addition and Multiplication Example**

minus sign. In this case, 2^3 is evaluated as 8, and then 8 is subtracted from

100. To indicate a unary minus, use =100
–
(
–
2^3).

ous powers.

Figure 9.1.

Figure 9.1.
Beware of the unary minus. Four similar formulas have differ-

Beware of the unary minus. Four similar formulas have differ-

ent results, depending on where the minus sign occurs.

ent results, depending on where the minus sign occurs.

Addition and Multiplication Example

The order of operations is important when you are mixing addition/subtraction

with multiplication/division. For example, if you want to add 20 to 30 and then

multiply by 1.06 to calculate a total with tax, the following formula leads

to the wrong result:

=20+30*1.06

The result you are looking for is 53. However, the Evaluate Formula dialog

shows that Excel calculates the formula =20+30*1.06 like so (see
Figure 9.2
):

1.06 × 30 = 31.8

31.8 + 20 = 51.8