If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Solver query
I'm trying to use the Solver to solve a problem for me,
but even though I've set binary constraints on the changing cells (ie I want them to be 1 or 0), the solver keeps making them into decimals, and producing solutions. How can I prevent this ? Basically, I've got a list of 30 amounts, of which I know a combination of 28 or 29 adds up to the target amount. I'm using a 1 or 0 in the changing cells as a multiplier, to try and work out which combination is correct. eg if the target is 100, the solution would be as follows: (imagine this set up in Excel) multiplier amount result 0 100 0 1 100 100 Total 100 My real problem is a bit more complicated, and even with binary constraints (and I've tried integer constraints), the Solver will invariable set the multiplier to a decimal and show it as the solution eg multiplier amount result 0.5 100 50 0.5 100 50 Total 100 Thanks |
Thread Tools | |
Display Modes | |
|
|