Gradebook formula

[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
(e-mail address removed)

PS I'm using Excel in OSX

 

[Domenic]

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

 

[JE McGimpsey]

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

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)