HR asks you to check the bonus rules for the sales team. Use IF, AND and IFERROR to turn the rules into formulas.
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
Both rules. Show "Bonus" in F2 if Anna met her target and had fewer than 3 sick days, otherwise "No bonus"
Bonus amount. Anna's bonus in G2: 5% of her sales if she met her target, otherwise 0
No errors. Bram's sales per sick day in G8. He had no sick days: show 0 instead of an error