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 .