Excel Goal Seek

[th284]

Is there a way to stop goal seeking once the target value reaches certain threshold? The issue is I am running some complex goal seek spreadsheet and it takes a long time to goal seek the exact value. If I can find a way to define a range rather the exact value it should improve the efficiency. Thank you.

 

[BeingYogi]

Whatever Chief ! Please post some sample data !

 

[pgc01]

Hi th284
Welcome to the board

Use the solver instead. It lets you control the process by defining not only the constraints precision (what I understood you want) but also for ex., the maximum execution time or the maximum number of iterations.

 

[th284]

For example:
Threshold = 50
Target Value = 100
Range("E9").GoalSeek Goal:=TargetValue+Threshold, ChangingCell:=Range("D9")

I want goalseek stop when Range("E9") actually is between (Target Value +1*Threshold) and (Target Value +2*Threshold), meaning as long as Range("E9") is <200 and >150 I am OK.

Will this do the trick?
Do
Range("E9").GoalSeek Goal:=TargetValue+Threshold, ChangingCell:=Range("D9")
Until Range("E9").value >=Target Value +1*Threshold AND Range("E9").value <=Target Value +2*Threshold
??

Thank you.