unknown function

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

i am a teacher and i am currently making a mark book.
eack term a student gets a form order which is either 1,
2, or 3 - this number relates to the third of the class
which the student is in (1 - top third, 2 - middle third
and 3 - last third). is there any function which will
calculate this automatically from the sutdents average
mark (out of 10) and/or their rank in the class. please
help and thank you in advance to whoever can help.

Adam Smith
 
Adam,

I think this will do what you want

=IF(A1<=COUNT(A:A)/3,1,IF(A1<=COUNT(A:A)/3*2,2,3))

If there is one more than an exact multiple of 3 pupils, there will be one
extra 3, if 2 more then 1 extra 3 and 1 extra 2.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top