How to Use CHOOSE Function | Microsoft Excel
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
Argument For Choose Function
value1,[value2]…: it can be a list, reference, and any data
Behavior of CHOOSE Function
Return of CHOOSE Function
Usage of CHOOSE Function
Error Values For CHOOSE Function
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.
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 Disgusting
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!