Microsoft Office Tutorials and References
In Depth Information
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.
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