Choose in Excel

Choose in Excel

This function picks from a list of options based upon an Index value given to by the user.

Microsoft Excel Function

=CHOOSE(UserValue, Item1, Item2, Item3 through to Item29)                                      

                                     

Formatting                                                                                                          

No special formatting is needed, the result will be shown as normal text.

Content Data

Index Value	Result
1	Shane	=CHOOSE(C4,"Shane","Jack","Mike")
2	Aston	=CHOOSE(C5,"Raj","Aston","Rose")'
3	Carol	=CHOOSE(C6,"Alan","Bob","Carol")
1	12%	=CHOOSE(C7,12%,15%,17%)'
2	15%	=CHOOSE(C8,12%,15%,17%)'
3	18%	=CHOOSE(C9,10%,15%,18%)'

Example

1. The following table was used to calculate the medals for athletes taking part in a race.                                                            
2. The Time for each athlete is entered.                                                          
3. The =RANK() function calculates the finishing position of each athlete.                                                                 
4. The =CHOOSE() then allocates the correct medal.                                                          
5. The =IF() has been used to filter out any positions above 3, as this would cause                                                           
6. the error of #VALUE to appear, due to the fact the =CHOOSE() has only three items in it.                                                                  

Name	Time	Position	Medal
Alan	1:30	2	Silver	=IF(D30<=3,CHOOSE(D30,"Gold","Silver","Bronze"),"unplaced")
Bob	1:15	4	unplaced	=IF(D31<=3,CHOOSE(D31,"Gold","Silver","Bronze"),"unplaced")
Carol	2:45	1	Gold	=IF(D32<=3,CHOOSE(D32,"Gold","Silver","Bronze"),"unplaced")
David	1:05	5	unplaced	=IF(D33<=3,CHOOSE(D33,"Gold","Silver","Bronze"),"unplaced")
Eric	1:20	3	Bronze	=IF(D34<=3,CHOOSE(D34,"Gold","Silver","Bronze"),"unplaced")
		=RANK(C34,C30:C34)