View Single Post
  #1   Report Post  
sumesh56 sumesh56 is offline
Senior Member
 
Posts: 118
Default 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?