Formula for Analizing Grades
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.....
|