Forum Discussion
Material Leftovers
Hello, I have possibly an unusual Formula request, but necessary for our company. We have material that is being cut and would like to see if there is a formula that I can use to figure out how ...
sg2021 Now, I'm not a mathematician, so there could be more intelligent ways to resolve this. But, the following formula will do the trick.
=MAX(INT(MatW/ProdW)*INT(MatL/ProdL),INT(MatW/ProdL)*INT(MatL/ProdW))MatW, ProdW, MatL and ProdL are named ranges, each referring to the Material's and Product's Width and Length. Dividing Widths and Lengths in both "directions" will enable you to determine the maximum amount of Product that can be cut out the Material. A working example is attached.
Thank you for your response! I will give this a shot and update if I cannot make it a go. Thanks!