School teacher

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

--

Vasant


"yeahbaby" <yeahbaby.1rf0rd@> wrote in message
news:vbOdnQGUZoIf117fRVn_vg@giganews.com...
>
> 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
news:vbOdnQGUZoIf117fRVn_vg@giganews.com...
>
> 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
news:vbOdnQGUZoIf117fRVn_vg@giganews.com...
>
> 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?

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

--

Vasant


"yeahbaby" <yeahbaby.1rf0rd@> wrote in message
news:vbOdnQGUZoIf117fRVn_vg@giganews.com...
>
> 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
news:vbOdnQGUZoIf117fRVn_vg@giganews.com...
>
> 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
news:vbOdnQGUZoIf117fRVn_vg@giganews.com...
>
> 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?

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
news:vbOdnQGUZoIf117fRVn_vg@giganews.com...
>
> 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
news:vbOdnQGUZoIf117fRVn_vg@giganews.com...
>
> 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
news:vbOdnQGUZoIf117fRVn_vg@giganews.com...
>
> 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?