Microsoft Office Tutorials and References

In Depth Information

**Using Cell References in Formulas**

FIGURE 15.8

Formula references to the sales tax cell should be absolute.

The quantity is multiplied by the price, and the result is multiplied by the sales tax rate

stored in cell B7. Notice that the reference to B7 is an absolute reference. When the formula

in D2 is copied to the cells below it, cell D3 will contain this formula:

=(B3*C3)*$B$7

Here, the references to cells B2 and C2 were adjusted, but the reference to cell B7 was

not — which is exactly what I want because the address of the cell that contains the sales

tax never changes.

Figure 15.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:

=$B3*C$2

FIGURE 15.9

Using mixed cell references

15

Notice that both cell references are mixed. The reference to cell B3 uses an absolute

reference for the column ($B), and the reference to cell C2 uses an absolute reference for the row