Select between multiple options
2000-02-05 Functions 0 225
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"