• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel IF Function Step by Step Tutorial

#### 6 of 8

Entering the Value If False Argument

Entering the Value If False Argument

### 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

Ted French