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


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

Adjust the array


if I got "and so on" wrong.



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

Thank you very much Aladin that was excellent!