Microsoft Office Tutorials and References

In Depth Information

=(B2*C2)*$B$7

The reference to cell B7 is an absolute reference. When you copy the formula in cell D2 to the cells below, the

$B$7 reference always points to the sales tax cell. Using a relative reference (B7) results in incorrect results in

the copied formulas.

Figure 2-5 demonstrates the use of mixed references. Note the formula in cell C3:

=$B3*C$2

Figure 2-4:
This worksheet demonstrates the use of an absolute reference.

This formula calculates the area for various lengths (listed in column B) and widths (listed in row 2). After you

enter the formula, it can then be copied down and across. Because the formula uses absolute references to row 2

and column B, each copied formula produces the correct result. If the formula uses relative references, copying

the formula causes the references to adjust and produce the wrong results.