MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Question concerning converting marks into grades


Posted by Bill on January 05, 2002 3:24 PM

Hi, I wonder if anyone out there can supply a solution to my insignificant little problem.
I want to enter a formula into my spreadsheet that will convert marks into grades.
The grade range is as follows:
31-40 = F, 41-50 = E, 51-60 =D and so on. What formula will I have to enter into G6 to make a value of 36 in F6 show grade F or a value of 58 show grade D.

Thanking you very very much in advance, Bill


Posted by Aladin Akyurek on January 05, 2002 3:35 PM

=VLOOKUP(F6,{31,"F";41,"E";51,"D";61,"C";71,"B";81,"A"},2)

where F6 houses a mark (which is apparently never less than 31!)

Adjust the array

{31,"F";41,"E";51,"D";61,"C";71,"B";81,"A"}

if I got "and so on" wrong.

Aladin

=======

Posted by Bill on January 05, 2002 3:56 PM

Thank you very much Aladin that was excellent!