I have been asked to compare estmated and actual student grades. As in - if a
student was predicted a B and received a C or A etc. can I show this step
(i.e. -1 or 1 grades out). Have put in an IF function (=IF(E9=F9,"OK","Not
OK") and I am wondering if I can say "if Not Ok the grade was out by -1,-2,
2, 3 etc. Hope that makes sense.....

Are you just dealing with standard letter grades (A,B,C,D,F)? If so, give
this a try:

=MATCH(E9,{"A","B","C","D","F"})-MATCH(F9,{"A","B","C","D","F"})

HTH,
Elkar


"Fairycastle" wrote:

I have been asked to compare estmated and actual student grades. As in - if a
student was predicted a B and received a C or A etc. can I show this step
(i.e. -1 or 1 grades out). Have put in an IF function (=IF(E9=F9,"OK","Not
OK") and I am wondering if I can say "if Not Ok the grade was out by -1,-2,
2, 3 etc. Hope that makes sense.....