Exercises / Modern Excel: dynamic arrays · 11 of 12
Name the parts of a formula with LET
LET(name1, value1, …, calculation) gives names to parts of a formula. Each part is written once and the formula reads like a sentence: =LET(price, A2, qty, B2, price*qty).
Your taskReps at or above the target in F1 earn the rate in F2, others the rate in F3. In C2, use LET to name the sales and the rate (pick the rate with IF), then return sales × rate. 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 | Target | $12,000.00 | |
| 2 | Amira | $15,800.00 | High rate | 8% | ||
| 3 | Bruno | $9,400.00 | Base rate | 5% | ||
| 4 | Chen | $12,000.00 | ||||
| 5 | Dana | $21,300.00 | ||||
| 6 | Elif | $6,800.00 | ||||
| 7 | Femi | $11,990.00 | ||||
| 8 | Gus | $13,450.00 |