Exercises / Logic and decisions · 5 of 9
Discount tiers with nested IF
An IF can sit inside another IF to pick between three or more results. Excel reads from the outside in and stops at the first TRUE test, so test the strictest condition first.
Your taskOrders of 1000 or more get 10% off, orders of 500 or more get 5%, smaller orders get 0. In C2, use IF to return the discount rate (0.1, 0.05 or 0) for the order in B2. It will be copied down to C8.
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 |
|---|---|---|---|
| 1 | Order | Amount | Discount |
| 2 | A-201 | $1,250.00 | |
| 3 | A-202 | $480.00 | |
| 4 | A-203 | $760.00 | |
| 5 | A-204 | $2,100.00 | |
| 6 | A-205 | $95.00 | |
| 7 | A-206 | $999.00 | |
| 8 | A-207 | $510.00 |