.

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)

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download