4.5 The IF Function (Module 4 Section 4.5)
A common use for the IF function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE.
STEP 1: Select IF FUNCTION – EXERCISE 7 tab on the data file “FUNCTIONS.xlsx”. Make cell D7 the active cell.
|
STEP 2: Special Note: “Help on this function” is at bottom of Insert Function dialog box shown in Steps 6 and 7 (FIGURE 3).
|
STEP 6A: In the “Logical_test” empty block, enter: “AVERAGE(B2:B6)>15000”
If the AVERAGE of cells B2:B6 is under 15000, then it is FALSE, and the result in cell D7 is 0. |
END OF PRACTICE EXERCISE 7
|
Practice Exercise 8: Create an IF formula using the IF function in a table
|
STEP 1: In the data file FUNCTIONS.xlsx, select the tab, IF FUNCTION – EXERCISE 8.
In this exercise, we will be assigning a Performance Bonus to employees with a Sales Classification of 4 or 5. If their classification is 1, 2, or 3, they do not receive a bonus.
END OF PRACTICE EXERCISE 8
|