Goalseek / Solver Target Value

  • Thread starter Thread starter msnews.microsoft.com
  • Start date 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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goalseek/Solver with calculation in targetted range 5
Using Excel Solver or Goalseek on multiple Sheets in a Workbook au 2
Using Solver in VBA 1
Excel 2003 + Solver 3
Problem with Goalseek Macro 5
How accurate is SOLVER? 1
Restricting Cell entry to certain letters 7
round result of sumif formula 13

Back
Top