exam marks into grades
How do I convert exam marks into grades using spcified grade boundaries?
|
exam marks into grades
Will this help. With marks in A1
=IF(A1<40,"FAIL",LOOKUP(A1,{40,60,70,80},{"D","C", "B","A"})) -- If this post helps click Yes --------------- Jacob Skaria "Sharon R" wrote: How do I convert exam marks into grades using spcified grade boundaries? |
exam marks into grades
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? |
exam marks into grades
=IF(A1<40,"FAIL",LOOKUP(A1,{40,60,70,80},{"D","C", "B","A"}))
Get rid off IF() =LOOKUP(A1,{0,40,60,70,80},{"FAIL","D","C","B","A" }) "Jacob Skaria" wrote: Will this help. With marks in A1 =IF(A1<40,"FAIL",LOOKUP(A1,{40,60,70,80},{"D","C", "B","A"})) -- If this post helps click Yes --------------- Jacob Skaria "Sharon R" wrote: How do I convert exam marks into grades using spcified grade boundaries? |
exam marks into grades
Teethless mama wrote...
=IF(A1<40,"FAIL",LOOKUP(A1,{40,60,70,80},{"D","C ","B","A"})) Get rid off IF() =LOOKUP(A1,{0,40,60,70,80},{"FAIL","D","C","B","A "}) .... Good intention, but fails on garbage and blank cells. Garbage (<0, 100, TRUE/FALSE, text) may but produce correct results. Blank produces FAIL. Probably closer to the OP's intent to use =IF(COUNT(A1),LOOKUP(A1,{-9.99999999999999E +306,0,40,60,70,80,100.000000000001}, {"Invalid","F","D","C","B","A","Invalid"}),"") |
All times are GMT +1. The time now is 12:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com