1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel IF Function Step by Step Tutorial

By

6 of 8

Entering the Value If False Argument
Entering the Value If False Argument

Entering the Value If False Argument

© Ted French

Entering the Value_if_false Argument

The Value_if_false argument tells the IF function what to do if the Logical Test is false.

The Value_if_false argument can be a formula, a block of text, a value, a cell reference, or the cell can be left blank.

In this tutorial we are testing to see if the data in cell E6 is less than $30,000. If it is not, we want the IF function to use a formula to multiply the employee's annual salary in cell E6 by the deduction rate of 8%, which is located in cell E4.

As with the preceding step, we will be entering the deduction rate ( E4 ) into the Value_if_true line of the dialog box as an absolute cell reference ($E$4 ).

This is being done to prevent cell reference errors from occurring when we copy the IF function to other cells later in the tutorial.

Tutorial Steps

  1. Click on the Value_if_false line in the dialog box.

  2. Click on cell E4 to add this cell reference to the Value_if_false line.

  3. Press the F4 key on the keyboard to make E4 an absolute cell reference ( $E$4 ).

  4. Press the asterisk ( * ) key on the keyboard. The asterisk is the multiplication symbol in Excel.

  5. Click on cell E6 to add this cell reference to the Value_if_false line.

  6. Note: We will not make E6 into an absolute cell reference because we want it to change when the function is copied.

  7. The completed Value_if_false line should read: $E$4 * E6.

  8. Click OK to close the dialog box and enter the completed IF function into cell F6.

  9. The value of $3,678.96 should appear in cell F6.

  10. Since B. Smith earns more than $30,000 per year, the IF function uses the formula $45,987 * 8% to calculate his annual deduction.

  11. When you click on cell F6, the complete function
    = IF ( E6<3000,$E$3*E6,$E$4*E6) appears in the formula bar above the worksheet

©2014 About.com. All rights reserved.