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... |
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... |
All times are GMT +1. The time now is 10:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com