Forum Discussion
Excel division
Hi, I would like to be assisted with a formula that can calculate as per below; 1. Check the Quantity ordered for a given variety and then divide this amount by the maximum pack rat...
Hi,
I have rephrased the excel question in a different way..." throwing a spanner in the works".
The maximum that can be packed in a box in 1500. After a box is filled up, then the division continues downwards i.e. if the left over is 200 for Jenny for box nr 3, then this will be filled up by 1300 sylvia which is the next variety.
I have attached an example file.
Please assist and thank you for your efforts.