| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Kelvin: What's the most suitable should I use??
I got a table which had 3 column for NAME, MARK and RANK.
What formula shall I use for let say I in put the mark between 100-81, the Rank there will shown as "A", between 80-61, the Rank there will shown as "B", between 60-40, the Rank there will shown as "C", Below 39 is "Fail" or etc... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Kelvin: What's the most suitable should I use??
=LOOKUP(B2,{0,40,61,81},{"Fail","C","B","A"})
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kelvin Lee" wrote in message ... I got a table which had 3 column for NAME, MARK and RANK. What formula shall I use for let say I in put the mark between 100-81, the Rank there will shown as "A", between 80-61, the Rank there will shown as "B", between 60-40, the Rank there will shown as "C", Below 39 is "Fail" or etc... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a suitable border for a religious text | Charts and Charting in Excel | |||
| How do I separate the last name only from say Kelvin F Pakaree? | Excel Discussion (Misc queries) | |||
| Advice pls, for suitable software for Server SBS | Excel Discussion (Misc queries) | |||
Linear Mode
