Spreadsheets+IF

Forest Cabinet Makers keep a weekly spreadsheet of employee pay, plus bonuses.



The Forename, Surname and Basic Rate are already entered in the sheet. The admin staff have to enter the number of units built by each employee during that week and the spreadsheet calculates the bonus payable (if any).

Currently the bonus is 10%, payable if the employee builds more than 8 units in the week. An IF statement is used to produce the calculation as follows:

=IF(D5>8, 0.1, 0)

Task
Produce this spreadsheet.

Task
Forest Cabinet Makers decide to change their bonus scheme as follows:
 * A minimum bonus of 5% is paid to every employee.
 * However, any employee who produces more than 12 units during the week will receive a bonus of 15%.

Write down the formula which will be used to calculate the new bonus.

Adapt your spreadsheet accordingly