ModeldrillScenario switch with CHOOSE
A financial modeling exercise from Modeldrill. Solve it with a live spreadsheet grid in your browser, with Fill right and Fill down, and it is checked the moment you submit.
The task
Three growth cases sit in rows 5 to 7. The number in B2 picks one. Fill the live growth row (row 8) with CHOOSE so it follows the switch, then revenue (row 9) grown by the live rate.
What this exercise teaches
With a live row in between, the rest of the model never needs to know which case is on. Flip one cell and every downstream number follows.
A hint if you get stuck
CHOOSE(index, option 1, option 2, option 3). Lock the switch; let the three options move with the column.
This exercise is part of Pro
Pro unlocks all 45 exercises, with worked solutions and progress saved to your account. The free exercises work without an account.
You create a free account first, so Pro is attached to it.
Monthly is charged today and then every month until you cancel, in one click from your account page. Lifetime is one payment with no renewals. Full refund within 14 days of paying.