Creating the IF Function
Step 1: Select the first empty cell in the Pass or Fail column.
Step 2: Open the Formula tab on the Excel ribbon. Click on the arrow underneath Logical in the Function Library section to expand the menu. Select IF from the menu options.
Step 3: In the Function Arguments window that appears on your screen, you will be asked for three items: the Logical test, the value if true, and the value if false.
In our example, we are testing to see if the value of the number in the Percentage Correct column is greater than or equal to 70. In Excel terms, this translates to the statement:
If this condition is true, we want the function to return the value “PASS". Otherwise, we want it to return the value “FAIL". A closer view of how this information is entered into the Function Arguments window can be seen below.
Step 4: Click OK after entering the information. The function will be immediately evaluated in the worksheet.
Step 5: Copy the formula just created and paste it into the other empty cells of the column.
Note: If for some reason the function is not evaluated or if it looks like it is being evaluated incorrectly, make sure that you have the Automatic calculations feature activated. To check this, click on the Calculation Options button in the Formula tab and see if there is a check mark next to Automatic.
Next in this series, we’ll take a look at how to create IF functions for conditions that have more than two possible values.