N Niek Otten Oct 31, 2004 #2 Sure we can help. Bur what's the problem you want to solve? -- Kind Regards, Niek Otten Microsoft MVP - Excel
Sure we can help. Bur what's the problem you want to solve? -- Kind Regards, Niek Otten Microsoft MVP - Excel
J Jay Oct 31, 2004 #3 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.
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.
