Sheets AcademySheets Academy
Premium
Task #18

Bonus for hitting the target

A manager gets a bonus of 5% of actual sales if they hit their target, meaning actual sales are not less than the target. Otherwise the bonus is 0.

  1. Calculate the bonus in D2.
  2. Drag the formula down to D7.
Task #18
Bonus for hitting the target

A manager gets a bonus of 5% of actual sales if they hit their target, meaning actual sales are not less than the target. Otherwise the bonus is 0.

  1. Calculate the bonus in D2.
  2. Drag the formula down to D7.