The title of my thread may refer to the solution to my question or perhaps to me. I guess I'll see.
Here is my problem/need. I work for a newspaper and we receive the morning paper in bundles of 50. I am working on a caculator that will tell my dock person exactly how may bundles and how many odd papers should be received off the truck on any given day.
Adding up each carrier's paper count and dividing them by 50. If, for example, I require 125 papers, I need this total to be reflected in two seperate cells. One to give me the total number of full bundles and one to give me the number of odd papers. In this case of course I would need 2 full bundles and 25 odd papers.
So here's where I'm stuck. Dividing the 125 papers by 50 gives me 2.5 bundles in the "Totoal Bundles" cell. I need this to round down to 2 bundles and the "Odd Papers" cell needs to read 25.
Can this be done?
Thanks
Bookmarks