Problem #3: The Goal Seeking Problem Has Multiple Solutions.Problem #2: Goal Seek Isn't Precise Enough.
#Goal seek excel how to
Therefore, in addition to introducing and explaining how you can use Goal Seek, I show how you can deal with some common challenges you may face when working with this feature.Īdditionally, since one of my main focuses at Power Spreadsheets is Visual Basic for Applications, the second part of this blog post explains how you can use Goal Seek (and deal with some of the challenges arising in connection with it) with VBA.Īs with all other Excel and VBA tutorials in Power Spreadsheets, this blog posts includes a detailed practical example that shows (step-by-step) how to implement everything. My purpose with this Excel tutorial is to provide all the information you need to start using Goal Seek now. Learning how to use Goal Seek is extremely helpful because, as I explain below, you can use Goal Seek whenever you know the resulting value that you want a particular formula to return but aren't sure what is the precise input that is required to achieve that result.
This particular Excel tutorial focuses on 1 of these What-If Analysis tools: Goal Seek. In Microsoft's words, What-If Analysis tools allow you to “try out various values for the formulas in your sheet“. One of the most popular group of features in Excel are the What-If Analysis tools.