School teacher
 

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!!


--
yeahbabyPosted from http://www.pcreview.co.uk/ newsgroup access

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

--

Vasant


"yeahbaby" <yeahbaby.1rf0rd@ wrote in message
...

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!!


--
yeahbabyPosted from http://www.pcreview.co.uk/ newsgroup access

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.


"yeahbaby" <yeahbaby.1rf0rd@ wrote in message
...

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!!


--
yeahbabyPosted from http://www.pcreview.co.uk/ newsgroup access

"yeahbaby" <yeahbaby.1rf0rd@ wrote in message
...

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!!


--
yeahbabyPosted from http://www.pcreview.co.uk/ newsgroup access


Perhaps we could see your 'look up' chart?