Excel IF Function Step by Step Tutorial

Copying the IF Function to Other Cells

Copying the Excel IF Function

© Ted French

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

1. Click on cell D1.
2. Place the mouse pointer over the black square in the bottom right corner. The pointer will change to a plus sign " + ".
3. Click the left mouse button and drag the fill handle down to cell D4.
4. 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.

• The IF Function - Step by Step
• Enter the Data for the IF Function
• Starting the IF Function
• Parts of the IF Function
• Writing the IF Function Logic Test
• Adding the "Value if True" Argument to the IF Function
• Adding the "Value if False" Argument to the IF Function
• Copying the IF Function to Other Cells