Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Mission

Mission: who gets a bonus?

HR asks you to check the bonus rules for the sales team. Use IF, AND and IFERROR to turn the rules into formulas.

  1. Target met?. HR's rules: you get a bonus if you reach your target and had fewer than 3 sick days. The bonus is 5% of your sales. Did Anna reach her target? Show "Yes" or "No" in E2
  2. Both rules. Show "Bonus" in F2 if Anna met her target and had fewer than 3 sick days, otherwise "No bonus"
  3. Bonus amount. Anna's bonus in G2: 5% of her sales if she met her target, otherwise 0
  4. No errors. Bram's sales per sick day in G8. He had no sick days: show 0 instead of an error

← All lessons