Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
CHOOSE as a scenario switch. CHOOSE(position, option1, option2, …) returns the option at a position: 1 gives the first, 2 the second. Point the position at one input cell and every formula fed by the result changes when that cell changes. IF or INDEX can do the same job.
=CHOOSE(H1,E2,E3,E4) picks a discount tier from a switch in H1
The van loan rate isn’t fixed yet, so finance keeps three rate scenarios in B6:B8 and a switch in B1 (1 Low, 2 Base, 3 High). It is set to High today, and the payment must follow whenever someone changes B1.
In B10, return the rate of the scenario chosen in B1, using a formula that reads B1. In B11, calculate the monthly payment on the price in B2 over the years in B3 at that rate, as a positive number rounded to 2 decimals.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Scenario (1 Low, 2 Base, 3 High) | 3 | ||||||
| 2 | Van price | $38,000 | ||||||
| 3 | Years | 5 | ||||||
| 4 | ||||||||
| 5 | Scenario | Annual rate | ||||||
| 6 | Low | 5.5% | ||||||
| 7 | Base | 6.5% | ||||||
| 8 | High | 8.0% | ||||||
| 9 | ||||||||
| 10 | Rate used | |||||||
| 11 | Monthly payment | |||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe