View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Formula Question

I work in a school and I need to tally the number of tickets grade levels
earn. What I am stuck on is, I want to tally the tickets earned, but when
they hit a certain number, the tally will start over again moving any carry
over ticket tallys with it. For example, the first grade has to earn 500
tickets. They end up earning 535. I want the tally to stop at 500 and move
that 35 into a new tally (rolling over the extra 35). Any help would be a
appreciated! Thanks!