Hi,

Enter grade boundaries in range C5:D9 where C5:C9 holds 0,40.60,80,90 and
D5:D9 holds E,D,C,B,A. This table can be read as "if the marks are between
41 and 60, the grade will be D, if the marks are between 81 and 90, the
grade will be B" so on and so forth.

now enter the marks in C11 and in cell D11, enter =VLOOKUP(C11,$C$5:$D$9,2)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sharon R" <Sharon wrote in message
...
How do I convert exam marks into grades using spcified grade boundaries?