Difference between revisions of "Manuals/calci/CHOOSE"
Jump to navigation
Jump to search
Line 69: | Line 69: | ||
*[http://en.wikipedia.org/wiki/String_(computer_science) String] | *[http://en.wikipedia.org/wiki/String_(computer_science) String] | ||
*[http://en.wikipedia.org/wiki/Comparison_of_programming_languages_(string_functions)#Find Find String] | *[http://en.wikipedia.org/wiki/Comparison_of_programming_languages_(string_functions)#Find Find String] | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Revision as of 05:27, 14 March 2017
CHOOSE(indexnum, val1, val2, .....)
where,
- the relative position of value to be selected
- are value arguments or cell references to the values
CHOOSE() selects a value from list of arguments with respect to the specified index position.
Description
CHOOSE(indexnum, val1, val2, .....)
e.g. CHOOSE(2,10,20,30) displays 20 as a result.
- CHOOSE() selects the value from the list of values depending on the specified . e.g. If is 2, Calci displays .
- If is not an integer, Calci displays #NULL error message.
- If <1 or > number of values in the list, Calci displays #N/A error message.
- Arguments can be numbers, text, cell references, formulas, functions etc.
Examples
Red | 23 | |
Blue | 12 | |
Yellow | 3 | |
Green | -1 | |
Orange | 4 |
=CHOOSE(5,A1,A2,A3,A4,A5) : Finds the value with index number '5' in the cell range A1 to A5.
Displays Orange. =CHOOSE(2,A1,A2,A3,A4,A5) : Finds the value with index number '2' in the cell range A1 to A5.
Displays Blue. =CHOOSE(4,B1,B2,B3,B4,B5) : Finds the value with index number '4' in the cell range B1 to B5.
Displays -1. =CHOOSE(10,B1,B2,B3,B4) : Specified index number '10' is greater than the cell range, hence
Calci displays #N/A error message.
Related Videos
See Also
References