It's important to be aware of the possibilities for how a relative cell reference might change when you move or copy a formula.
Note: You can also copy formulas into adjacent cells by using the fill handle . After verifying that the cell references in the formula produce the result that you want in step 4, select the cell that contains the copied formula, and then drag the fill handle over the range that you want to fill.
Moving formulas is very much like moving data in cells. The one thing to watch for is that the cell references used in the formula are still what you want after you move.
Tip: You can also copy and paste a formula to another cell or worksheet. |