Microsoft Office Tutorials and References
In Depth Information
Working with Formulas
division (/), and fi nally it performs addition (+) and subtraction (−). For example, the
following formula returns the value 23 because multiplying 4 by 5 takes precedence over
adding 3:
=3+4*5
If a formula contains two or more operators with the same level of precedence, the
operators are applied in order from left to right. In the following formula, Excel fi rst
multiplies 4 by 10 and then divides that result by 8 to return the value 5:
=4*10/8
When parentheses are used, the value inside them is calculated fi rst. In the
following formula, Excel calculates the (3+4) and then multiplies that result by 5 to return the
value 35:
=(3+4)*5
Figure 1-20 shows how slight changes in a formula affect the order of precedence and
the result of the formula.
Figure 1-20
Order of precedence applied to Excel formulas
Formula
Application of the Order of Precedence
Result
=50+10*5
10*5 calculated first and then 50 is added
100
=(50+10)*5
(50+10) calculated first and then multiplied by 5
300
=50/10–5
50/10 calculated first and then 5 is subtracted
0
=50/(10–5)
(10–5) calculated first and then 50 is divided by that value
10
=50/10*5
Two operators at same precedence level, so the calculation is done
left to right in the expression
25
=50/(10*5)
(10*5) calculated first and then 50 is divided by that value
1
Inserting a Formula
• Click the cell in which you want the formula results to appear.
• Type = and a formula that calculates a value using cell references and arithmetic
operators.
• Press the Enter key or press the Tab key to complete the formula.
Amanda wants the worksheet to include the total amount she charged for creating
each customer’s DVDs. The charge is equal to the number of DVDs created multiplied
by the price per DVD. You’ve already entered this information for each customer in
columns F and G. You’ll enter a formula to calculate the charge for each customer in
column H.
Search JabSto ::




Custom Search