Microsoft Office Tutorials and References
In Depth Information
Using cell references in formulas
Figure 12-3 We copied the relative references from cell F4 to cells F5:F8.
Copying absolute references If you want cell references to remain the same when you
copy them, use absolute references. For example, in the worksheet on the left in Figure
12-4, cell B2 contains the hourly rate at which employees are to be paid and cell C5
contains the relative reference formula =B2*B5. Suppose you copy the formula in C5 to the
range C6:C8. The worksheet on the right in Figure 12-4 shows what happens: you get
erroneous results. The formulas in cells C6:C8 should refer to cell B2, but they don’t. For
example, cell C8 contains the incorrect formula =B5*B8.
Figure 12-4 The formula in cell C5 contains relative references. We copied the relative formula
in cell C5 to cells C6:C8, producing incorrect results.
You’ll find the Wages.xlsx file with the other examples on the companion website.
Because the reference to cell B2 in the original formula is relative, it changes as you
copy the formula to the other cells. To correctly apply the wage rate in cell B2 to all the