Level 2LogicPractice, 3 min
Commission tiers with IFS
The task
The commission rate depends on quota attainment: 120% or more pays 10%, 100% or more pays 8%, 80% or more pays 5%, anything less pays 0%. In C2, return the rate for the attainment in B2 with
IFS.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Rep | Attainment | Rate | Tier | Rate | |
| 2 | Lena | 107% | 120%+ | 10% | ||
| 3 | 100% to 119% | 8% | ||||
| 4 | 80% to 99% | 5% | ||||
| 5 | Under 80% | 0% |