Goalseek / Solver Target Value
 

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

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