Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting problem - newspapers
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Startup Problem | Excel Discussion (Misc queries) | |||
Problem with MS Community Newsgroups? | Excel Discussion (Misc queries) | |||
Counting Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Problem with counting characters in a cell | Excel Worksheet Functions |