in reply to Re^2: determine numbers of boxes needed per weight
in thread determine numbers of boxes needed per weight

Using the distribute function above, the minimum box weight would be 37.5 lbs, except where the total weight is less than that figure; and you will only ever need to look up one price as they will always be the same.

If you need to limit your weight to greater than 50 lbs, then you will inevitably have to do 2 lookups more often than not.

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
Lingua non convalesco, consenesco et abolesco. -- Rule 1 has a caveat! -- Who broke the cabal?
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
  • Comment on Re^3: determine numbers of boxes needed per weight

In Section Seekers of Perl Wisdom