ExcelBanter - how to convert grades into a value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to convert grades into a value (https://www.excelbanter.com/excel-discussion-misc-queries/448345-how-convert-grades-into-value.html)

sumesh56

how to convert grades into a value

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?

Mazzaropi

Quote:

Originally Posted by sumesh56 (Post 1610096)

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 example here.

sumesh56

Quote:

Originally Posted by Mazzaropi (Post 1610159)

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 example here.

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

sumesh56

Quote:

Originally Posted by sumesh56 (Post 1610270)

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

All times are GMT +1. The time now is 06:21 AM.