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!!
School teacher
- Thread starter yeahbaby
- Start date