View Single Post
  #1   Report Post  
Rick Kaullen Rick Kaullen is offline
Junior Member
 
Posts: 1
Default Solver Binary Contraints problem

I'm using Solver to determine which combination of numbers in a column result in the given total.

For example, the data is in E1:E42 and I've set J1:J42 to 0.
$J$43 = SUMPRODUCT(E1:E2*J1:J42)
$J$44 = the value I'm searching for
$J$45 = J44-J43 and is the Solver Target Cell
I'm Solving to 0 by changing cells $J$1:$J$42
Subject to the Constraints: $J$1:$J$42=binary

When I set the constraint to binary, instead of setting the changeable cell from 0 to 1, it sets the cells to a large decimal between 0 and 1.
I've also tried adding the integer constrait to no avail.
Is there any way to force Solver to limit the values of the changeable cells to either a 0 or 1?
Thanks.