Ron Matthews
Board Regular
- Joined
- Feb 4, 2008
- Messages
- 51
I WANT TO FIND WHICH NUMBERS ADD UP TO $8452.55
[TABLE="width: 170"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD="align: right"]$3,208.20[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$185.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$180.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$529.74[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$893.76[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$201.39[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$185.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$276.81[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$3,718.72[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$2,376.89[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$473.73[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]$13,841.24[/TD]
[/TR]
</tbody>[/TABLE]
I have set Solver up as shown above and no matter which method I use, I cannot get a result.
I have tried unsuccessfully on Excel XL for Windows, Excel 2011 and 2016 for Mac
I suspect I am doing something wrong in the set up - can some-one please help me?
[TABLE="width: 170"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD="align: right"]$3,208.20[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$185.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$180.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$529.74[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$893.76[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$201.39[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$185.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$194.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$276.81[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$3,718.72[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$2,376.89[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD="align: right"]$473.73[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]$13,841.24[/TD]
[/TR]
</tbody>[/TABLE]
I have set Solver up as shown above and no matter which method I use, I cannot get a result.
I have tried unsuccessfully on Excel XL for Windows, Excel 2011 and 2016 for Mac
I suspect I am doing something wrong in the set up - can some-one please help me?