Grades

[Amy]

what is the funtion to post a letter grade corresponding
with the percentage you receive

 

[PTT, Inc.]

There is a sample IF function in the HELP menu that will do exactly what you
want. For example, if your final grade is in cell F1 you can put a formula
in G1 that says:

=IF(F1>89,"A",IF(F1>79,"B", IF(F1>69,"C",IF(F1>59,"D","F"))))

All you have to do is to change the "F1" to what cell your grade is in. The
easiest way to see the sample is to click in your cell, click the "Fx"
(Insert Function) icon on the Formula Bar, click the "IF" statement to
highlight it, then click "Help on this function" at the bottom of the dialog
box. This example is in that HELP menu topic.

Hope this helps!

Bill Foley
www.pttinc.com

 

[J.E. McGimpsey]

Depends on how the percentage translates to letter grades, doesn't
it?

One way:

Make a table of your grades and their minimum score, e.g,:

J K
1 0 F
2 60% D-
3 63% D
4 67% D+
5 70% C-
....
14 97% A+

Then, if your percentage is in A1 use

=VLOOKUP(A1, J:K, 2, TRUE)

to return your letter grade.

 

[Bernard Liengme]

Hi Amy,
IF has its limitations. Why not use
=HLOOKUP(A1,{49,60,70,80,90;"F","D","C","B","A"},2,TRUE)
modified to taste
Bernard