Module VI· Sensitivity & Scenario AnalysisIntermediate
Question
How do you model scenarios with switch cells and CHOOSE function?
Answer
Create a scenario switch cell: 1 for downside, 2 for base, 3 for upside. Store assumptions in columns by scenario. Use CHOOSE(switch, downside, base, upside) or INDEX to pull the active assumption. This makes scenarios visible, auditable, and easy to connect to output summaries.