how to convert grades into a value

[sumesh56]

i have a worksheet. in which i have grades in col C. I want to get thes
grades converted into a value in col D. suppose grades are lik
this..
in C5=A1 C6=B1 C7= D1
i want to convert ----- A1 into 10 B1 into 8
AND D1 into 6. how can i accomplish this

 

[maccboy]

Hi
If you want the value of the A1 in cell D5 (alongside cell C5) you can use a nested if function:
=IF(C5="A1",10,IF(C5="B1",8,6))

maccboy

 

[GS]

sumesh56 was thinking very hard :

i have a worksheet. in which i have grades in col C. I want to get
these grades converted into a value in col D. suppose grades are
like this..
in C5=A1 C6=B1 C7= D1
i want to convert ----- A1 into 10 B1 into 8
AND D1 into 6. how can i accomplish this?

My Student Grades Manager app uses a lookup table to pull letter grades
and point averages into the Summary module (named range) of a class
sheet. This works on ranges of total marks so that if the mark falls in
a range of the GradesTable then the appropriate letter grade and point
average populates their respective columns for each student in the
class. So there a column for FinalAvg, FinalGrade, and PointAvg.

If you set your grades up in a named table so your formulas can use a
LOOKUP function then you can use the same formula in all cells. The
table can be H or V. (I use HLOOKUP above the FreezePanes row)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Mazzaropi]

i have a worksheet. in which i have grades in col C. I want to get thes
grades converted into a value in col D. suppose grades are lik
this..
in C5=A1 C6=B1 C7= D1
i want to convert ----- A1 into 10 B1 into 8
AND D1 into 6. how can i accomplish this?

I´m not sure if I understood correctly your necessity.

Try to do this one: Cell D5 --> =IF(C5="A1",10,IF(C5="B1",8,6))

If it´s not what your looking for, try explain with a worksheet exampl
here

 

[sumesh56]

I´m not sure if I understood correctly your necessity.

Try to do this one: Cell D5 --> =IF(C5="A1",10,IF(C5="B1",8,6))

If it´s not what your looking for, try explain with a worksheet exampl
here.

let me check it and tell whether it works or not,. btw, i got an idea t
do this using the vlookup funtion. but yours seems to be simple compare
to that . let me see. thanks for the suggestion. have a nice day

 

[sumesh56]

let me check it and tell whether it works or not,. btw, i got an idea t
do this using the vlookup funtion. but yours seems to be simple compare
to that . let me see. thanks for the suggestion. have a nice day.

thanks a lot for this suggestion. it works perfectly. this is what
wanted.have a nice day