Goalseek / Solver Target Value

  • Thread starter msnews.microsoft.com
  • Start date
M

msnews.microsoft.com

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
 
B

bpeltzer

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