Thread: Averages
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Moss Steve Moss is offline
external usenet poster
 
Posts: 7
Default Averages

I have a student marking sheet with 2 colums, one is "Individual grade" for
each subject, and the second for "Overall Grade". what i am trying to do is
use the individual grades "A+, A, A-, B, B- etc" to automatically calculate
an Overall grade. for instance Biology, Chemistry and Physics all have
individual grades, but as a collective "Science" they need an average grade.
Can anybody help.