School teacher

Y

yeahbaby

We assess students in three criteria, and need to work out an overal
grade. For example, A+ A+ A+ would work out to an overall A+. I hav
a 'look up' chart for myself that I manually check to see what thre
grades are equivalent to, but how do i get Excel to look at thre
cells, and place a (pre-determined) value into a final cell. And no
it is not as simple as a 15 point average (ie A+ to E-)!! Hope someon
can help out and save me time!
 
V

Vasant Nanavati

Since you are a teacher, you might want to try explaining the problem a bit
more clearly! :)
 
L

Lewis Clark

Do your letter grades convert to numeric values? If so, you can convert
each letter grade to a number, calculate your average, and then convert back
to the letter grade.
 
V

Vic Sowers

yeahbaby said:
We assess students in three criteria, and need to work out an overall
grade. For example, A+ A+ A+ would work out to an overall A+. I have
a 'look up' chart for myself that I manually check to see what three
grades are equivalent to, but how do i get Excel to look at three
cells, and place a (pre-determined) value into a final cell. And no,
it is not as simple as a 15 point average (ie A+ to E-)!! Hope someone
can help out and save me time!!
Click to expand...

Perhaps we could see your 'look up' chart?
 
Top