Page 232 - Excel 2007 Bible

16_044039 ch11.qxp 11/21/06 11:04 AM Page 189
FIGURE 11.8
Formula references to the sales tax cell should be absolute.
Figure 11.9 demonstrates the use of mixed references. The formulas in the C3:F7 range calculate the area
for various lengths and widths. The formula in cell C3 is
FIGURE 11.9 =$B3*C$2 Introducing Formulas and Functions 11
Using mixed cell references.

Notice that both cell references are mixed. The reference to cell B3 uses an absolute reference for the col-
umn ($B), and the reference to cell C2 uses an absolute reference for the row ($2). As a result, this formula
can be copied down and across, and the calculations will be correct. For example, the formula in cell F7 is
=$B7*F$2
If C3 used either absolute or relative references, copying the formula would produce incorrect results.
The workbook that demonstrates the various types of references is available on the companion
ON the CD-ROM CD-ROM. The file is named cell references.xlsx.
ON the CD-ROM
NOTE When you cut and paste a formula (move it to another location), the cell references in the for-
NOTE
mula aren’t adjusted. Again, this is usually what you want to happen. When you move a for-
mula, you generally want it to continue to refer to the original cells.

189