Entering the Nested IF Function Logical_test Argument
As mentioned in the previous step, we still have two deduction levels left to deal with:
- employees with a salary between $30,000 and $49,999
- and those with a salary greater than or equal to $50,000
The Logical_test of the nested IF function can be written so that it breaks down the two remaining deduction levels into two mutually exclusive groups.
The two groups will be:
- employees with a salary of less than $50,000
- employees with a salary greater than or equal to $50,000
Note: We do not have to worry about those employees with a salary of less than $30,000 being included with the group who make less than $50,000 because the first IF function has already dealt with them.
Employees who make less than $30,000 have been removed from the data being used for the second IF function .
Tutorial StepsFollowing the open round bracket " ( " entered in the previous step,
- Click on cell E7 to enter that cell reference at the beginning of the nested IF function Logical_test.
- Press the less than key " < " on the keyboard.
- Type 50000 after the less than symbol.
- Type a comma ( , ) AFTER the 50000.
- At this point, the nested IF function on the Value_if_false line should read:
if (E7 < 50000,
Note: The comma is used as a separator between the three arguments of the IF function. When using the dialog box to enter the IF function, Excel enters the comma for us.
When typing in the function, entering a comma in any location other than as a separator between the three arguments will cause an error in the final results.