Microsoft Office Tutorials and References

In Depth Information

Relative references are useful when you summarize rows of data and want to use the same

formula for each row. As an example, suppose you have a worksheet with two columns of

data, labeled
SalePrice
and
Rate
, and you want to calculate your sales representative’s

commission by multiplying the two values in a row. To calculate the commission for the first

sale, you would type the formula
=B4*C4
in cell D4.

Selecting cell D4 and dragging the ill handle until it covers cells D4:D9 copies the

formula from cell D4 into each of the other cells. Because you created the formula using

relative references, Excel updates each cell’s formula to reflect its position relative to the

starting cell (in this case, cell D4.) The formula in cell D9, for example, is
=B9*C9
.