Difference between revisions of "Manuals/calci/CHOOSE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=CHOOSE(indexnum, val1, val2, .....)= | =CHOOSE(indexnum, val1, val2, .....)= | ||
| + | <div style="font-size:30px">'''CHOOSE () '''</div><br/> | ||
where, | where, | ||
| − | * | + | *First Parameter is the relative position of value to be selected |
| − | * | + | *From the second parameter are value arguments or cell references to the values |
CHOOSE() selects a value from list of arguments with respect to the specified index position. | CHOOSE() selects a value from list of arguments with respect to the specified index position. | ||
| Line 9: | Line 10: | ||
== Description == | == Description == | ||
| − | CHOOSE( | + | CHOOSE() |
e.g. CHOOSE(2,10,20,30) displays '''20''' as a result. | 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 | + | *CHOOSE() selects the value from the list of values depending on the specified in the first parameter. e.g. If first parameter is 2, Calci displays in the second parameter. |
| − | *If | + | *If the first parameter is not an integer, Calci displays #NULL error message. |
| − | *If | + | *If the first parameter <1 or the first parameter > number of values in the list, Calci displays #N/A error message. |
| − | *Arguments | + | *Arguments from the second parameter can be numbers, text, cell references, formulas, functions etc. |
== Examples == | == Examples == | ||
Revision as of 15:42, 6 August 2018
CHOOSE(indexnum, val1, val2, .....)
CHOOSE ()
where,
- First Parameter is the relative position of value to be selected
- From the second parameter 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()
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 in the first parameter. e.g. If first parameter is 2, Calci displays in the second parameter.
- If the first parameter is not an integer, Calci displays #NULL error message.
- If the first parameter <1 or the first parameter > number of values in the list, Calci displays #N/A error message.
- Arguments from the second parameter 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