Share via

Binary constraints in Excel solver not working

Anonymous
2015-05-12T06:08:12+00:00

Excel is not following the binary constraints set.

For example, the data is in E1:E42 and I've set J1:J42 to 0.

$J$43 = SUMPRODUCT(E1:E2*J1:J42) 

$J$43 = Solver Target Cell

I'm Solving to get $J$43 as a particular number 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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2015-05-13T16:38:13+00:00
    0 comments
  3. Anonymous
    2015-05-14T12:15:44+00:00

    I cannot reproduce this. Can you put a file on a file share site like OneDrive?

    best wishes

    4 people found this answer helpful.
    0 comments
  4. Anonymous
    2016-07-22T16:44:45+00:00

    I just fixed a similar issue. Silly default settings ruin my life.

    Go to Solver > Options > Uncheck "Ignore Integer Constraints"

    Thanks for other forum help!

    174 people found this answer helpful.
    0 comments