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

File:Calci1.gif

---