Select between multiple options

 2000-02-05    Functions    0    105

The logical function IF(logical_test,if_true,if_false) can be used up to 7 times within one formula. Such a function will be very complicated due to the large number of parentheses and separator signs. By using the CHOOSE(index,choice1,choice2,...)-function it's easy to select between up to 29 different alternatives. The only limitation is that the index value must be a number between 1 and 29.

Examples:

=CHOOSE(2,"First","Second","Third","Fourth")
Returns the text "Second"

=CHOOSE(3,1000,2000,3000,4000)
Returns the number "3000"