Choose

Uses index_num to return a value from the list of value arguments. Use CHOOSE to select values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.

Syntax

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

The CHOOSE function syntax has the following arguments:

• indexNumber (Required) Specifies which value argument is selected.

  • If indexNumber is 1, CHOOSE returns value1; if it is 2, CHOOSE returns value2; and so on.
  • If indexNumber is less than 1 or greater than the number of the last value in the list, CHOOSE returns blank.

• Value1, value2, ... Value 1 is required, subsequent values are optional. The arguments can be numbers, field references, defined names, formulas, functions, or text.

Remarks

• The value arguments to CHOOSE can be range references as well as single values.

For example, the formula:

=SUM(CHOOSE(2,[1][1]:[1][10],[2][1]:[2][10],[3][1]:[3][10]))

evaluates to:

=SUM([2][1]:[2][10])

which then returns a value based on the values in the range [2][1]:[2][10].

The CHOOSE function is evaluated first, returning the reference [2][1]:[2][10]. The SUM function is then evaluated using [2][1]:[2][10], the result of the CHOOSE function, as its argument.

Examples

Data

Example 2