ok i want to have my excel gradebook tell me in a column by the students averages say F D C B A the scale roughly is 0-64 F, 65-74 D, 75-83 C, 85-92 B 93-100 A
i need an if or if else etc to set this up
anbd how to set up a column on the side to properly display the reference scale and to call from it to display the Letter Grade
2007-01-19 15:13:17 · 2 answers · asked by Anonymous in Computers & Internet ➔ Software
=IF(A1<=64,"F",IF(A1<=74,"D",IF(A1<=83,"C",IF(A1<=92,"B","A"))))
Try this also.
2007-01-22 13:38:40 · answer #1 · answered by unnga 6 · 0⤊ 0⤋
A............. ..........B............ ...... ....... ....... C.... .... D.... ... E
15 . =VLOOKUP(A1,$D$1:$E$5,2) ................0.......F
72 . =VLOOKUP(A2,$D$1:$E$5,2) ................65......D
88 . =VLOOKUP(A3,$D$1:$E$5,2) ..............75......C
96 . =VLOOKUP(A4,$D$1:$E$5,2) ...............85......B
............... ................... .................. .................... 93 ......A
Number grade entered in column A
Column B displays the letter grade
column C is blank
column D and E is the lookup table to find the grades
Ignore the dots they are there to help line things up
2007-01-20 00:15:42 · answer #2 · answered by Brian 5 · 1⤊ 0⤋