Calculation of combinations



I have an issue.

Lets say I have 4 numbers (10, 50, 100, 250) and I want excel to give me the best combination of those numbers that will get me as close as possible to a target value of 999.

I can use the each number more than once (obviously).

 And I want to duplicate the calculation for a lot of cells (each time the target value is different)


How can I do that?


Thanks in advance for the answers,


By: Adam

Leave a Reply

Your email address will not be published. Required fields are marked *