CHOOSE

What Does It Do?

This function picks from a list of options based upon an Index value given to by the user.

Syntax =CHOOSE(UserValue, Item1, Item2, Item3 through to Item29)

Formatting No special formatting is required.

Example The following table was used to calculate the medals for athletes taking part in a race. The Time for each athlete is entered. The =RANK() function calculates the finishing position of each athlete. The =CHOOSE() then allocates the correct medal. The =IF() has been used to filter out any positions above 3, as this would cause the error of #VALUE to appear, due to the fact the =CHOOSE() has only three items in it.