View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fairycastle Fairycastle is offline
external usenet poster
 
Posts: 1
Default 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.....