CHOOSE Function is used to get one indexed value from the list of the values.
For example, there are 7 days Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday and the days have arranged in sequence 1 to 7. 1=Monday, 2=Tuesday... and so on
You have to use CHOOSE Function to get the value. If you use 2 number then CHOOSE Function will return the second day(Tuesday) from the list, If you use 5 number then CHOOSE will return the fifth day(Friday) from the list.
Syntax of CHOOSE Function
=CHOOSE(index_num,value1,[value2]...)
Argument For Choose Function
index_number: it is a number of the index value to return data from the list. Index number should be in between 1 to 254
value1,[value2]...: it can be a list, reference, and any data Behavior of CHOOSE Function
For Example,
You have four month names January, February, March, and April are in a sequence of 1 to 4.
You are using the function
=CHOOSE(3, C4,C5,C6,C7)
Here 3 is the index number which indicates the value on the 3 rd number must be returned from the list.
For this, the CHOOSE function will return the value located on cell number C6, Which is March.
Return of CHOOSE Function
CHOOSE Function will return the data of the index value from the list
Usage of CHOOSE Function
CHOOSE Function is used to get a single value from the list by giving an index number
Error Values For CHOOSE Function
Error Commands  Description  
#VALUE 

More Examples
Example 1 Giving an opinion from 1 to 5 as 1 For Excellent, 2 For Good, 3 For Average, 4 For Poor, 5 For Disgusting.
Here you have five values and five data.Values
You have to write five values and data in a column as shown in the figure. here data and values are placed as per above description. 1 For5 Excellent .... 5 For DisgustingReturns
Choose function will return the opinion as per the numbering from 1 to 5.CHOOSE function fetches the number in cell E4 and return the value assigned to the reference data which is cell number C5 is AVERAGE.
This is the same for number 1 to 5 where 5 will return Disgusting.
_________________________________________________________________________
How would you like this content to write us in the comment box!
If you face any difficulty in the content feel free to ask!
Thank You.
No comments:
Post a Comment