Choose

Syntax

Choose(Index,  Choice1, Choice2, Choice3, ..., ChoiceN)

Description

Choose one item from a list of choices, depending on the value of Index.  The value for Index will be rounded to the nearest integer.  If Index is not between 1 and n, the function will return zero as the result.

Example

Choose(Month, 10, 15, 18, 22, 25, 30, 40, 32, 27, 17, 12, 5) = 10 in January, 15 in February, 18 in March, etc.