Copying the IF Function to Other Cells
To complete the worksheet, we need to add the IF function to cells D2, D3, and D4. Since our data is laid out in a regular pattern, we can copy the IF function in cell D1 to the other three cells. As the function copied, Excel will update the cell references to reflect the functions new location.
To copy down our function we will use the Fill Handle.
For our tutorial
- Click on cell D1
- Place the mouse pointer over the black square in the bottom right corner. The pointer will change to a plus sign " + ".
- Click the left mouse button and drag the fill handle down to cell D4.
- Release the mouse button. Cells D2 - D4 will be filled with the IF function.
Notice how the cell references in the IF function have been change in cells D2 to D4 to reflect the IF functions new location.