annoying_stuff
New Member
- Joined
- May 16, 2011
- Messages
- 1
I am working on a spreadsheet where I need to take a grand total and divide it by a number and come up with a full amount that is equally divisible and instead of a decimal value, I need it to show me the number of complete units + the complete number of the left overs. We have orders for books that we have to fill. Each box that we will ship can hold only 20 books. If a customer orders 93 books, I need to be able to show on the packing tag that the complete order consists of 4 full boxes and 1 box of 13. I can't figure out if there is a way in excel to do this without always coming up with a decimal of 4.65 Is this possible to do in excel? And if so, could the order be listed in different columns?
Example
Order 93 / Full Boxes 4 / Partial Box 13
Thanks so much in advance for helping me!
Example
Order 93 / Full Boxes 4 / Partial Box 13
Thanks so much in advance for helping me!
Last edited: