Excel help with Solver Add In

Factual Questions
1

Anyone here familiar with the Solver add-in for Excel?
In short it allows you to define a problem and it will run numbers through it until it finds a solution that matches your criteria.

The particular problem I’m trying to solve is trying to find out which numbers in a column will add up to a specific number.

For reference, I’m trying something like this: Identifying Excel Entries that Add Up to a Specific Value -

The problem I’m having is that the multiplier column is supposed to be 0 or 1, but it’s placing decimal numbers in that column; instead of simple binary 0 or 1.

I’ve tried setting the constraints Range = Binary, and also by adding multiple constraints; i.e. >= 0; <= 1; and integer. Still the same problem.

Any help?

2

It sounds like you’re doing it right by setting the constraint to binary, so I’m not sure what’s going wrong. I followed the instructions in the linked article and it worked fine for me. Are you sure your constraint is correct? If you had the constraint only on the first cell in the multiplier column for example, it will set other values in the column to decimal values.