Microsoft Office Tutorials and References

In Depth Information

**Working with Formulas**

division (/), and ﬁ 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 ﬁ 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 ﬁ 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.