=MOD(A2,500)
--
David Biddulph

"Ben" wrote in message
...
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!