Microsoft Office Tutorials and References

In Depth Information

Figure 22-3:
Formulas in the range C4:C7 use an absolute reference to cell C1.

Notice that the reference to cell C1 is an absolute reference. When the formula is copied to other cells in column

C, the formula continues to refer to cell C1. If the reference to cell C1 were a relative reference, the copied for-

mulas would return an incorrect result.

Operator precedence problems

Excel has some straightforward rules about the order in which mathematical operations are performed in a for-

mula. In Table 22-1, operations with a lower precedence number are performed before operations with a higher

precedence number. This table, for example, shows that multiplication has a higher precedence than addition.

Therefore, multiplication is performed first.

Table 22-1: Operator Precedence in Excel Formulas

Symbol

Operator

Precedence

–

Negation

1

%

Percent

2

^

Exponentiation

3

* and /

Multiplication and division 4

+ and –

Addition and subtraction

5

&

Text concatenation

6

=, <, >, and <> Comparison

7