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..... |
Formula for Analizing Grades
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..... |
All times are GMT +1. The time now is 09:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com