- Open "task3" which you saved in the previous lesson.
- In the ACME Brush Company, bonuses are paid if a salesman sells more than 150 items. Your task is to enter formulae into the green cells below, (using the IF function) to decide if the salesman gets a bonus or not.
Save this spreadsheet as "task4" in your "Excel" folder. |