Goal Seeker Giving Wrong Answer
 

It may be my error, but it appears goal seeker is giving me the wrong answer.

A1=238
A2=389
A3=36080
A4=(A1+A2)/A3 = 0.017378

I want to find what value is needed in A3 to give the result of 0.0110 in A4.

If I do it manually, the number in A3 needs to be 57000. Goal Seeker is
telling me it should be 54105.

What am I doing wrong?

Goal Seeker Giving Wrong Answer
 

ToolsOptionsCalculation tab, set Maximum change to something like 0.0000000000001

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Glenn" wrote in message ...
| It may be my error, but it appears goal seeker is giving me the wrong answer.
|
| A1=238
| A2=389
| A3=36080
| A4=(A1+A2)/A3 = 0.017378
|
| I want to find what value is needed in A3 to give the result of 0.0110 in A4.
|
| If I do it manually, the number in A3 needs to be 57000. Goal Seeker is
| telling me it should be 54105.
|
| What am I doing wrong?
|

Goal Seeker Giving Wrong Answer
 

Niek,

Thank you for your prompt, accurate answer!

"Niek Otten" wrote:

ToolsOptionsCalculation tab, set Maximum change to something like 0.0000000000001

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Glenn" wrote in message ...
| It may be my error, but it appears goal seeker is giving me the wrong answer.
|
| A1=238
| A2=389
| A3=36080
| A4=(A1+A2)/A3 = 0.017378
|
| I want to find what value is needed in A3 to give the result of 0.0110 in A4.
|
| If I do it manually, the number in A3 needs to be 57000. Goal Seeker is
| telling me it should be 54105.
|
| What am I doing wrong?
|