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!
