I am needing a non-Macro or Solver approach to this problem:
1. I have a pole (say...360 cm) that needs to be built using two different length pieces (20 & 50 cm).
2. I need a best combination of the building pieces so that I am given exactly or slightly over the total pole height.
3. I was using TRUNC w/ 50s first and then filling the rest with 20s, until I realized that is not accurate. (360 would actually be 6x50s and 3x20s)
4. I am forced to use Google Spreadsheets for this "calculator", so it must not contain macros or use Solver.
Thank you for your help!
Bookmarks