Manuals/calci/CHOOSE

Revision as of 21:31, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''CHOOSE'''</font></font></font><font color="#4848...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
 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