Friday, 2 September 2016

Excel CHOOSE Function

How to use the Excel CHOOSE function













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)















No comments:

Post a Comment