Select between multiple options

 2000-02-05    Functions    0    156

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.


Returns the text "Second"

Returns the number "3000"