With this table in cells A1:B2
BundleSize____25
Extras________3

Try something like this:

A4: Needed
B4: (route delivery count)

A5: Stock Amount

This formula returns the number of bundles and loose papers to stock:
B5: =INT((B4+B2)/B1)&" BUNDLES AND "&MOD(B4+B2,B1)&" LOOSE"

Example:
B4: 76
B5 returns: 3 BUNDLES AND 4 LOOSE

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"TckyTina" wrote in message
...
I want to build a formula for a newspaper company. Their bundle size is 25
papers per bundle and deliveries might have 3 bundles + 3 loose
newspapers.
How do I create a formula to show this? They want to use this for people
who
are getting bundles ready for delivery - but do not want to use a decimal
system. Please let me know any ideas.