Forum Discussion
formula packaging optimisation
Hello I have a project to optimize the calculation of the necessary packaging product A is made available in 1000kg, 200kg, 2.5kg If I have 1346kg of product for sale I want to optimize the ...
yan1983 I don't think you need all these complicated formulae. Please have a look and see if this works for you. The formula in B5 was copied down to B8. Though, the one in B8 needed to be changed to use ROUNDUP rather than INT. Easy to adjust if you need more layers in between.