View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default 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