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