This will get you started in the right direction:
=LOOKUP(A1,{0,"F";2,"C";2.3,"C+";2.7,"B-";3,"B";3.3,"B+";3.7,"A-";4,"A"})
HTH
Jason
Atlanta, GA
"Angelo D" wrote:
I am working on a spreadsheet in Excel for Grades for my students. I need to
set letter grades to numeric equivalents (A = 4.0, A- = 3.7, etc) then have
the final grade show up as a Letter (A, A-, B+, etc.) Part II of this is I
have 9 grades each equal to a certain % of the Final grade (totaling
100%).... Help! Thanks Angelo D
|