Creating a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Tina

Try
=INT(A1/25)&" - "&MOD(A1,25)
where A1 holds the number of newspapers required.

You can make the separator whatever you wish.
The above sets the results as 3 - 3
 
One way:

If A1 has the number of papers:

Bundles:

A2: =INT(A1/25)

Loose Papers:

A3: =A1-A2

or, in one cell:

=INT(A1/25) & " bundles + " & MOD(A1,25) & " loose"
 
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)
 
Back
Top