1. Open "task3" which you saved in the previous lesson.
  2. 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.

iffunction 

Save this spreadsheet as "task4" in your "Excel" folder.

task4
Home
Revision
Functions (1)
Functions (2)
Editing
Charting
Customize
back to top