Calculation of combinations

Hi,

 

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,

Adam.

By: Adam

Leave a Reply

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