CHOOSE EXCEL FORMULA

EXCEL FORMULA
Function Dictionary Function Examples Function Categories

CHOOSE

         
 
 
Index Value Result
1 Alan  =CHOOSE(C4,"Alan","Bob","Carol")
3 Carol  =CHOOSE(C5,"Alan","Bob","Carol")
2 Bob  =CHOOSE(C6,"Alan","Bob","Carol")
3 18%  =CHOOSE(C7,10%,15%,18%)
1 10%  =CHOOSE(C8,10%,15%,18%)
2 15%  =CHOOSE(C9,10%,15%,18%)
What Does It Do?              
This function picks from a list of options based upon an Index value given to by the user.
Syntax                
 =CHOOSE(UserValue, Item1, Item2, Item3 through to Item29)
Formatting              
No special formatting is required.
Example                
The following table was used to calculate the medals for athletes taking part in a race.
The Time for each athlete is entered.
The =RANK() function calculates the finishing position of each athlete.
The =CHOOSE() then allocates the correct medal.
The =IF() has been used to filter out any positions above 3, as this would cause
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)