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
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.