Grades to numbers

Assuming achieved grade is in column A, and target grade is in column B, then you can have this in C1:

=CODE(SUBSTITUTE(B1,"A*","@"))-CODE(SUBSTITUTE(A1,"A*","@"))

Hope this helps.

Pete

Thanks that worked a treat!

Thanks for the rep - If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

I think it would be even more robust if you did this:

=CODE(SUBSTITUTE(UPPER(B1),"A*","@"))-CODE(SUBSTITUTE(UPPER(A1),"A*","@"))

then you could use upper or lower case letters to record the grades.

Pete