If you think about it, you'll realize that the only reason why you would ever need to change a reference is if you plan to copy the formula. Figure 3-1 demonstrates why this is so. The formula in cell C3 is

A |
e |
C |
[> |
E |
G | ||||

1 |
Width | ||||||||

2 |
10 |
2.0 |
1.5 | ||||||

3 |
vo |
1J0 |
l.S |
3,0 |
l.S | ||||

4 |
5 □i |
1.5 |
1.5 |
23 |
3.0 |
j. a | |||

5 |
2.0 |
2.0 |
3.0 |
4.0 |
5.0 | ||||

i |
2.5 |
2.S |
3-3 |
3,0 |
6.3 | ||||

7 |
3.0 |
J.O |
A.S |
6.0 |
7.5 | ||||

8 9 | |||||||||

u |
Shiit] |
i-.-.r* StlMitt j ¡4 [ |

Figure 3-1: An example of using nonrelative references in a formula.

Figure 3-1: An example of using nonrelative references in a formula.

This formula calculates the area for various lengths (listed in column B) and widths (listed in row 3). After the formula is entered, it can then be copied down to C7 and across to F7. Because the formula uses absolute references to row 2 and column B and relative references for other rows and columns, each copied formula produces the correct result. If the formula used only relative references, copying the formula would cause all the references to adjust and thus produce incorrect results.

Was this article helpful?

## Post a comment