Quote:
Originally Posted by sumesh56
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?
|
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.