Microsoft Office Tutorials and References

In Depth Information

**Chapter 12: Building formulas**

Excel performs multiplication and division before addition and subtraction.

●

Excel calculates consecutive operators with the same level of precedence from left to

right.

●

Type some formulas to see how these rules apply. Select an empty cell, and type
=4+12/6
.

Press Enter, and you see the value
6
. Excel first divides 12 by 6 and then adds the result

(2) to 4. Then select another empty cell, and type
=(4+12)/6
. Press Enter, and you see the

value
2.666667
. This demonstrates how you can change the order of precedence by using

parentheses. The formulas in Table 12-1 contain the same values and operators, but note

the different results caused by the placement of parentheses.

TABLE 12-1
Placement of parentheses

Formula

Result

=3*6+12/4–2

19

=(3*6)+12/(4–2)

24

=3*(6+12)/4–2

11.5

=(3*6+12)/4–2

5.5

=3*(6+12/(4–2))

36

If you do not include a closing parenthesis for each opening parenthesis in a formula, Excel

displays the message “Microsoft Excel found an error in this formula” and provides a

suggested solution. If the suggestion matches what you had in mind, simply press Enter, and

Excel completes the formula for you.

When you type a closing parenthesis, Excel briefly displays the pair of parentheses in bold.

This feature is handy when you are typing a long formula and are not sure which pairs of

parentheses go together.

Note

If you are unsure of the order in which Excel will process a sequence of operators, use

parentheses even if the parentheses aren’t necessary. Parentheses also make your

formulas easier to read and interpret, which is helpful if you or someone else needs to

change them later.