View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Creating a formula

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
--
Regards
Roger Govier



"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.