Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solver does not work from Macros | Setting up and Configuration of Excel | |||
solver problem | Excel Worksheet Functions | |||
Excel Solver Issue | Excel Discussion (Misc queries) | |||
Trouble with Solver | Excel Discussion (Misc queries) | |||
Solver problem | Excel Discussion (Misc queries) |