Goal Seek

  • Thread starter Thread starter Jamie Hart
  • Start date Start date
Hi

basically it's used to change an input variable so that the result of the
formula equals what you want it to ...
say i have the following
A B C
1 10 20 =A1+B1

now C1 will give me 30, but if i want to know what B1 will need to be if i
want C1 to show 50, i can use goal seek

Set C1 to value of 50 by changing B1

Hope this helps


Cheers
JulieD
 

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

about goal seek 1
Solver and Goal Seek-Tutorial 1
How to use goal seek on column 4
Goal Seek Question 1
Button for goal seek?! 6
Goal seek via macro? 1
Goal Seek 1
Automate Goal Seek? 2

Back
Top