How do I use Goal Seek?

N

Niek Otten

Sure we can help.

Bur what's the problem you want to solve?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
J

Jay

i'm not quite sure how to use goal seek .. can anyone help me?

Here's an simple example.

Suppose to want to calculate the square root of the number in A1.

In A3, put
=A2*A2-A1

Invoke
Tools >> Goal seek
with
Set cell: A3
To value: 0
By changing cell: A2

When you click OK twice, the square root appears in A2.

Of course, the easier way to calculate a square root is SQRT(A1), but this
example illustrates goal seek.
 
Top