With the letter-grade in cell A1 use
=LOOKUP(A26,{"A","B","C","D"},{3,2,1,0}) to get numeric grade
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Irene" wrote in message
...
I have to replace letters A, B, C which were used as a mark to figures in
the
total amount formula according to A=3, B=2, C=1.
Could you advise me if I can do it in Excel?

Thank you in advance