Logical decisions
CHOOSE function: switch forecast scenarios with a 1-based selector
Pick the 1st, 2nd, or 3rd assumption cell from a numbered scenario input, and catch out-of-range selector numbers that trigger #VALUE!.
Three growth assumptions controlled by one selector cell
Financial models often place a scenario number (1, 2, or 3) in E2 to switch between Conservative (0.03 in B2), Base (0.06 in B3), and Stretch (0.10 in B4) revenue growth.
| Selector value | Scenario | Growth rate |
|---|---|---|
| 1 | Conservative (B2) | 0.03 |
| 2 | Base (B3) | 0.06 |
| 3 | Stretch (B4) | 0.1 |
Pick the Nth argument with CHOOSE
CHOOSE(index_num, value1, value2, value3) is 1-based: when E2 is 2, =CHOOSE(E2, B2, B3, B4) returns B3 (0.06). Multiplying base revenue 50,000 by (1 + CHOOSE(E2, B2, B3, B4)) gives 53,000.
=CHOOSE(E2,B2,B3,B4)Out-of-bounds index numbers return #VALUE!
If E2 is less than 1 (such as 0) or greater than the number of supplied choices (such as 4), CHOOSE returns #VALUE!—making invalid selector inputs immediately visible rather than silently falling back.
Try the example
Use the original values or change them to test your understanding.