- The ACME Brush Company pays bonuses as follows:
- No bonus under 150 sales
- 150 to 175 sales, bonus of $20.00
- 176 to 200 sales, bonus of $40.00
- Over 200 sales, bonus of $60.00
- Open the spreadsheet called "task4" which you saved in the previous exercise.
- Enter the above bonus payment data as a lookup table somewhere on your spreadsheet out of the way of the rest of your work.
- In the cells of row 13 (just as you saw in the example in the lesson), enter formulae which check how much (if any) bonus must be paid for each of the months.
- Save this spreadsheet as "task5" in your "Excel" folder.
|