View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default Goalseek / Solver Target Value

Well if you want to get cell A20 to equal cell B20, for example, you could
create a formula in A21: =A20 - B20, and set the goal to have A21 be 0.

"msnews.microsoft.com" wrote:

Guys
Is there a way to reference a cell as the "target value" as far as I can see
both tools require me to enter an interger.

Thanks in advance
Kevan