Im trying to find a way, either with Excel or another program, to find out what combination of numbers will equal a predetermined sum. Ive tried Excel Help and the internet, and it appears possible, but all the examples are far more complicated than what Im trying to do and they dont seem to work for me. Heres an example of what Im trying to do:
If I have the following set of numbers:
1.00
1.50
2.00
2.30
2.90
5.30
5.40
6.30
6.90
7.40
7.80
8.30
9.50
Id like to find out which combinations will total 9.6 and 9.7; the same number can be used multiple time (i.e. 1.00 eight times plus 1.5 = 9.5)
It seems like ?Solver in Excel should work for this, but I cant get the results I want.