Manuals/calci/CHOOSE
CHOOSE(i_num,val1,val2,...)
where i_num specifies which value argument is selected and i_num should be a number between 1 and 29.
- When i_num is 1, CHOOSE gives value1and when it is 2, CHOOSE gives value 2; and so on.
val1,val2,... are the value arguments .
It calculates a value from the list of value arguments.
CHOOSE
Let's see an example in Column1Row1 , Column1Row2,Column1Row3,Column1Row4
Red
Green
Yellow
Blue
I.e =CHOOSE(2,C1R1,C1R2,C1R3,C1R4) is green
Syntax
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | Red | |||
Row2 | Green | |||
Row3 | Yellow | |||
Row4 | Blue | |||
Row5 | Green | |||
Row6 |