grade score

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Apiwat - 14 Jul 2004 02:03 GMT

how to change grade (A,B,C) to 4,3,2 score

Reply to this Message

CLR - 14 Jul 2004 02:39 GMT

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

> how to change grade (A,B,C) to 4,3,2 score

Reply to this Message

Peo Sjoblom - 14 Jul 2004 03:11 GMT

With the grade in A1

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

Signature

Regards,

Peo Sjoblom

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

> how to change grade (A,B,C) to 4,3,2 score

Reply to this Message