Solver doesn't know Integers??

[fred]

I'm using solver to fix some problems. And I specifically stated on one of the constraints:


$D$3:$D$27 = INTERGER

$D$3:$D$27 <= 1

$D$3:$D$27 >= 0


I would think the answer from D3 to D27 would be either 0 or 1. But I'm getting decimal answers filling out the entire area. Did I do anything wrong?


I have sent Chandoo a sample file. I don't know how to upload a file to here.

 

[Luke M]

Usually people upload their files to a free site (like rapidshare) and just post the link here.


W/o your workbook, I'm unable to duplicate the problem. (Solver works correctly)Granted, I don't know all the constraints...is Solver saying it's found a solution, or just come close?

 

[fred]

it does give me an answer. However, it is giving me all the answers in decimal points when the solution should be integers.

 

[keymaster]

It seems like you have checked "ignore integer conditions" option in the solver. Uncheck and solve again.

 

[Hui]

or

Setup some helper cells

=mod(Number,1)

and add some more conditions where Helper cell = 0