Hi

For your bundles, use
=INT(2678/60)
and for your singles use
=2678-(60*bundles)

With your total in A2 and your bundle size in A3 use:
INT(A2/A3) in A4 for bundles and
=A2-(A3*A4) for singles.

Hope this helps.
Andy.

"Mike Saffer" wrote in message
...
Hello again,

I would make a simple sheet showing a count of newspapers to our delivery
drivers. They are making mistakes calculating complete and partial
bundles
in their head.

They are used to seeing their total newspaper count for the day expressed
as
X bundles and X singles. For instance, if the diver has 2678 newspapers
and
they come bundled 60 papers to each bundle, that's 44 bundles and 38
singles.

My sheet looks like this so far:

A
1 2678 (total papers)
2 60 (bundle count)
3 44.6333 (bundles)

I would like it to look like below but can't seem to break out the partial
bundle count (the singles) into another cell.

A
1 2678 (total papers)
2 60 (bundle count)
3 44 (bundles)
4 38 (singles) <~ 60 X .6333 rounded up

Does anyone has a soluotion for this one?

Much obliged,
Michael
Jacksonville, Florida










--
Mike
Jacksonville, Florida