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).
Figure 9.1 shows the results of four formulas involving raising 2 to vari-
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
Search JabSto ::




Custom Search