Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
target cells in solver
i need more than one target cell in the solver..... i have two variables that
have to merge to zero not be exactly zero.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
target cells in solver
The target cell must be a single cell. Try this. Use the ABS function
on the two cells you want near zero, then make the Solver target the sum of those two cells and minimize it. Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
target cells in solver
On Jun 16, 4:29 pm, merjet wrote:
The target cell must be a single cell. Try this. Use the ABS function on the two cells you want near zero, then make theSolvertarget the sum of those two cells and minimize it. Hth, Merjet Don't do ABS unless you absolutely have to. It's non-linear and could give you a ton of trouble. If you have two variables a and b that you want to minimize, then make your objective function simply min a + b. If a + b must be greater than 0, then you have to add a secondary constraint, a + b = some small value (epsilon). SteveM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Several target cells in the solver | Excel Discussion (Misc queries) | |||
How do I set more than 1 target cell using MS Solver? | Excel Worksheet Functions | |||
How to get Solver to target array rather than cell? | Excel Worksheet Functions | |||
Goalseek / Solver Target Value | Excel Worksheet Functions | |||
Help - loop through cells in a range that are not together (several different cells as Target) | Excel Programming |