grade score

  • Thread starter Thread starter Guest
  • Start date Start date
You could use the Edit > Replace feature three times to find A and replace
with 4, and find B and replace with 3, etc.............or you could use a
helper column and put in a formula like

=IF(A1="A",4,IF(A1="B",3,IF(A1="C",2,""))) and copy it down the helper
column.

Vaya con Dios,
Chuck, CABGx3
 
With the grade in A1

=IF(A1="","",LOOKUP(A1,{"A";"B";"C"},{4;3;2}))



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top