Gradebook formula

H

Harry

Hi folks,

Grades are due Monday and I'm out of time to try and figure this one out.

Can any one help me write a simple grade book formula that calculates a
letter grade (A,B,C,D,F) including plus and minus grades, from a
percentage in another cell?

I've tried to use an IF formula but can't seem to get it right. the
complexity of greater than and less than sequencing is too much for this
tired overworked Spanish teacher to tackle

Thanks,

Please reply to me directly
[email protected]

PS I'm using Excel in OSX
 
D

Domenic

Can you provide the corresponding percentages for each of the letter
grades, including plus and minus grades?
 
J

JE McGimpsey

Harry <[email protected]> said:
Grades are due Monday and I'm out of time to try and figure this one out.

Can any one help me write a simple grade book formula that calculates a
letter grade (A,B,C,D,F) including plus and minus grades, from a
percentage in another cell?

I've tried to use an IF formula but can't seem to get it right. the
complexity of greater than and less than sequencing is too much for this
tired overworked Spanish teacher to tackle
Click to expand...

One way:

Assume that the total percentage is in column J. In column K enter:

K2: =LOOKUP(J2,{0,0.6,0.7,0.8,0.9},{"F","D","C","B","A"})

Alternatively, build a table, say in a separate worksheet (Sheet2):

A B
-------- -------
1 0 F
2 60% D
3 70% C
4 80% B
5 90% A

then use

K2: =VLOOKUP(J2, Sheet2!$A:$B, 2, TRUE)
 
Top