Excel Homework for all 3rd form classes

Due dates:
3A and 3C - Day 1 Cycle 4
3D - Day 3 Cycle 4

In notebooks

Using the Spreadsheet below, write IF Statements for the following:

1. Let’s suppose sales have to be greater than or equal to $100K for a salesman to receive a 12% bonus, write the If Statement that would be applicable for this scenario.
2. Now let's suppose that sales have to be greater than or equal to $100K for a salesman to receive a 12% bonus; or greater than or equal to $200K for a salesman to receive a 15% bonus; but suppose sales is less than $100K, then the salesman will only receive 5% bonus.  Write the If Statement that would be applicable.
3. Write the if statement that would be placed in Cell C3 to state if the difference between the maximum and the minimum is $10,000 or more, the minimum should be increased by 5%; otherwise it should remain the same.
4. Using the same spreadsheet, lets practice writing criteria for filtering.  First, let's extract all Sales that are greater than $100,000.00  Write the applicable criterion.