Excel - Show as whole number + remainder (left over)

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!
 
Last edited:

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
If A1 contains 93, then =DOLLARFR(A1/20, 20) returns 4.13. Would that be clear enough?

Format the result as 0.00
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,516
Messages
6,179,231
Members
452,898
Latest member
Capolavoro009

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top