Excel: How to seperate decimal #'s or other suggestions...

[ThatNewGuy]

Hello,

First let me explain the application I am trying to sort out and then perhaps someone can suggest a better way of doing this bcuz I think I'm going down the wrong track.

I'm working with numbers in a production environment where the number of items ordered is constantly changing for specific part #'s. For example, if the customer orders 2500 total items we know that 90 items fit into a box. So if you do the math that means that 27 boxes with 90 items in them accounts for 2,430. I'm still short 70 items to complete my total order of 2500. To complete the order I have 27 boxes of 90 and 1 box of 70. Is there a way that excel can calculate this out if given the constant such as, 90, and the number of items ordered?

In this example i divided the qty of 2500 by 90 items per box which equals 27.77778. I've tried working with decimals like 27.77778 but I don't know if and how to seperate the whole number from the decimals in excel. This would solve my problem by taking the .77778 * 90= 70 items in a box. But I'm trying to automate the process so the formula would simply tell the end user that he needs 27 boxes with 90 and 1 box with 70.

Any suggestions would be greatly appreciated. Thx.

 

[AnotherHiggins]

If
[tab]A1 = 2500 (Parts Ordered)
And
[tab]A2 = 90 (Parts per Box)

Then to find the number of full boxes, use:
[tab]=Int(A1/B1)
This will return 27

To find the remainder to go into the last box, use:
[tab]=Mod(A1,B1)
This will return 70

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.