1. Computing

Excel IF Function Step by Step Tutorial


3 of 8

Starting the IF Function
Starting the IF Function

Starting the IF Function

© Ted French

Opening the IF Function Dialog Box

Although it is possible to just type the IF function into a cell in a worksheet, many people find it easier to use the function's dialog box to enter the function.

In this tutorial, we want to use the same function in a number of cells. The first step will be to enter the function into one cell in the group and then copying it to the rest.

Tutorial Steps

  1. Click on cell F6 to make it the active cell. This is where we will enter the IF function.

  2. Click on the Formulas tab.

  3. Click on the Logical icon on the ribbon to open the Logical function drop down list.

  4. Click on IF in the list to bring up the IF function's dialog box.

The data that we enter into the three blank rows in the dialog box will form the arguments of the IF function.

These arguments tell the function what condition we are testing and what actions to take depending on whether the condition is true or not.

©2014 About.com. All rights reserved.