CHOOSE practice

CHOOSE returns one value from a list by its position number. Below are the 1 financial modeling exercise on Modeldrill that use it, each checked instantly in your browser.

Syntax

CHOOSE(index, value1, [value2], ...)

What people get wrong

A common scenario switch: put the case number in one cell and let CHOOSE pick the assumption for it.

financial modeling exercise that use CHOOSE

• Scenario switch with CHOOSELevel 5Pro