Help on Solver function with constraints

[Chi]

Hello,

I am trying to use the solver function to minimize the target cell (say A1) by changing cells B1 to B30, where B1 to B30 can only contain either 0 or 1. How can I set this criteria?

Thanks for help!

 

[pgc01]

Hi Chi

I believe you can do it by adding 3 criteria

$B$1:$B$30>=0
$B$1:$B$30<=1
$B$1:$B$30=integer

Hope this helps
PGC