View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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?
|