"Goal Seek" limits for the "Variable cell"

[vic]

Hi!
I just tried "goal seek" tool for the first time.
Would it be hard to add the options to specify the limits (min and max) within which to search/attempt different values for the "Variable cell"?

thanks

[SuperTech]

Goal Seek in PlanMaker works by approximation and offers only four settings — Formula cell, Target value, Variable cell and Accuracy. There is currently no option to restrict the search to a minimum and maximum value for the variable cell. I have forwarded your improvement suggestion.

Until then, two things influence the outcome: enter a realistic starting value in the variable cell before running the Goal Seek, since the approximation proceeds from the value found there, and reduce Accuracy so the result has to come closer to your target value.