Entering the Value_if_false Argument
The Value_if_false argument tells the IF function what to do if the Logical Test is false.
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.
This is being done to prevent cell reference errors from occurring when we copy the IF function to other cells later in the tutorial.
- Click on the Value_if_false line in the dialog box.
- Click on cell E4 to add this cell reference to the Value_if_false line.
- Press the F4 key on the keyboard to make E4 an absolute cell reference ( $E$4 ).
- Press the asterisk ( * ) key on the keyboard. The asterisk is the multiplication symbol in Excel.
- Click on cell E6 to add this cell reference to the Value_if_false line.
- Note: We will not make E6 into an absolute cell reference because we want it to change when the function is copied.
- The completed Value_if_false line should read: $E$4 * E6.
- Click OK to close the dialog box and enter the completed IF function into cell F6.
- The value of $3,678.96 should appear in cell F6.
- Since B. Smith earns more than $30,000 per year, the IF function uses the formula $45,987 * 8% to calculate his annual deduction.
- 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