Microsoft Office Tutorials and References
In Depth Information
Creating formulas to calculate values
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.