|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|