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