#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 846
Default Goal Seek precision

What I would like to do is to have Goal seek give me the closest number, to
the true answer, down to the penny. If the correct answer is 99.995859694 -
the answer should be 100.

Can I tell goal seek to stop once the input changes by less than a penny?

If the answer is to change the options-calculation-maximum iterations and
maximum change. My follow up question is what other features of Excel do
these two items control?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 846
Default Goal Seek precision

I did got the answer by the following code - is there a better way?

Sub monthly_income_benefit_accumulation()
Worksheets("input_info").Range("c50").GoalSeek
goal:=Worksheets("input_info").Range("c52"), _
Changingcell:=Worksheets("input").Range("c13")
Application.ScreenUpdating = True
Worksheets("input").Range("c13") =
Application.WorksheetFunction.RoundUp(Worksheets(" input").Range("c13"), 2)
End Sub


"Brad" wrote:

What I would like to do is to have Goal seek give me the closest number, to
the true answer, down to the penny. If the correct answer is 99.995859694 -
the answer should be 100.

Can I tell goal seek to stop once the input changes by less than a penny?

If the answer is to change the options-calculation-maximum iterations and
maximum change. My follow up question is what other features of Excel do
these two items control?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
goal seek tikchye_oldLearner57 Excel Discussion (Misc queries) 3 August 31st 06 02:52 PM
Goal seek gone [email protected] Excel Worksheet Functions 2 August 29th 06 04:57 PM
Goal Seek Mike Excel Worksheet Functions 3 January 23rd 06 04:39 AM
Goal Seek Jake Excel Discussion (Misc queries) 1 June 12th 05 05:55 AM
Goal Seek Tiya Excel Worksheet Functions 1 May 11th 05 12:38 PM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"