Exercises / Logic and decisions · 2 of 9
Pay commission above a threshold
IF can return a calculation, not just text: =IF(test, B2*rate, 0). Keep the threshold and the rate in their own cells and anchor them, so changing a policy is one edit.
Your taskReps earn commission only when sales reach the threshold in F1. In C2, use IF to return the sales in B2 times the rate in F2 when B2 is at least F1, and 0 otherwise. 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 | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Rep | Sales | Commission | Threshold | $10,000.00 | |
| 2 | Amira | $12,450.00 | Rate | 5% | ||
| 3 | Bruno | $9,800.00 | ||||
| 4 | Chen | $10,000.00 | ||||
| 5 | Dana | $15,200.00 | ||||
| 6 | Elif | $7,300.00 | ||||
| 7 | Femi | $11,050.00 | ||||
| 8 | Gus | $8,990.00 |