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....

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

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