Microsoft Office Tutorials and References

In Depth Information

**Creating formulas to calculate values**

3

Selecting cell C2 and dragging the ill handle through cell C7 copies the formula from cell

C2 into each of the other cells. Because you created the formula by using relative

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

(in this case, cell C2.) The formula in cell C7, for example, is
=A7*B7
.

You can use a similar technique when you add a formula to an Excel table column. If the

sale price and rate data were in an Excel table and you created the formula
=A2*B2
in cell

C2, Excel would apply the formula to every other cell in the column. Because you used

relative references in the formula, the formulas would change to reflect each cell’s distance

from the original cell.