CHOOSE

CHOOSE Function in Microsoft Excel


Command: CHOOSE

Syntax: =choose(cell referencing #,value 1, value 2, value 3…value 29)

Example 1:

=choose($A$1,B1,B2,B3)

If cell A1 = 1, then it will return cell B1

If cell A1 = 2, then it will return cell B2

Use: Financial modeling for upside and downside cases.  Easy to use and describe.

Limitations: Only 29 possible variables.  Offset is easier to manipulate.