Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Goal Seek

Status
Not open for further replies.

Noo

Technical User
Oct 1, 2001
3
ZA
Hi

Does anyone knwo how to change the precision in goalseek?

Thanks
Noo
 
I suppose you are talking Excel?

Tools, Options, Choose Calculation Tab, Adjust Maximum Difference and Check Precision as Displayed.

Be aware however that in this case Excel may not be able to reach the goal exactly.

If my assumption (Excel) is correct, you better post your question in the Microsoft Office Forum _________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]
 
Thanks a mill!. i am actually using excel's goalseek but via vba, so I suppose changing the precision in excel would affect what i'm doing.
Thanks
Noo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top