A
Amy
what is the funtion to post a letter grade corresponding
with the percentage you receive
with the percentage you receive
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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
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
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.
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.
B
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
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