Exercises / Logic and decisions · 3 of 9
Bonus only when both targets are met
AND(test1, test2, …) is TRUE only when every test is TRUE. Put it inside IF to act on several conditions at once.
Your taskAn employee gets a bonus when sales (B2) are at least G1 AND the rating (C2) is at least G2. In D2, use IF and AND to return "Bonus" or "No bonus". It will be copied down to D8.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Employee | Sales | Rating | Bonus? | Sales target | $50,000.00 | |
| 2 | Ana | $62,000.00 | 4 | Rating target | 4 | ||
| 3 | Ben | $48,500.00 | 5 | ||||
| 4 | Clara | $50,000.00 | 4 | ||||
| 5 | Dev | $71,200.00 | 3 | ||||
| 6 | Esra | $39,900.00 | 2 | ||||
| 7 | Finn | $55,300.00 | 5 | ||||
| 8 | Gia | $50,100.00 | 3 |