I take that back - the above was not an accurate solution... is the below better ?
I4:
=INDEX(F$4:F$7,MATCH(MIN(IF(($F$4:$F$7>=$C$4)*($G$4:$G$7>=$D$4),MOD($F$4:$F$7,$C$4)*$D$4+MOD($G$4:$G$7,$D$4)*INT($F$4:$F$7/$C$4))),MOD($F$4:$F$7,$C$4)*$D$4+MOD($G$4:$G$7,$D$4)*INT($F$4:$F$7/$C$4),0))
confirmed with CTRL + SHIFT + ENTER and copied to J4
So waste is determined by: waste height * width + waste width * complete units (as determined by height)
Example:
250/175 would return 1250/350 rather than 500/230 given the former leaves no waste whatsoever
Bookmarks