Excel Nested IF Function Step by Step Tutorial

By Ted French, About.com Guide

Copying the Nested IF Function using the Fill Handle

To complete the worksheet, we need to add the IF function to cells F8 to F11.

Since our data is laid out in a regular pattern, we can copy the IF function in cell F7 to the other four cells.

As the function is copied, Excel will update the relative cell references to reflect the function's new location while keeping the absolute cell reference the same.

To copy down our function we will use the Fill Handle.

Tutorial Steps

For help with these instructions, click on the image above.

1. Click on cell F7 to make it the active cell.


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 F11.


4. Release the mouse button. Cells F8 to F11 will be filled with the results of the IF function.


5. If you have followed the steps of this tutorial your worksheet should resemble the example on page 1 of this tutorial.

Return to Index page