More precisely, it determines what value you should enter in an input cell to get the desired result in a formula cell. Goal Seek is Excel's built-in What-If Analysis tool that shows how one value in a formula impacts another. In this particular tutorial, we will focus on one of Excel's What-If Analysis tools - Goal Seek.
In other words, it enables you to see the impact of making a certain change without changing the real data.
In most general terms, What-If Analysis allows you to test out various scenarios and determine a range of possible outcomes. What-If Analysis is one of the most powerful Excel features and one of the least understood. The tutorial explains how to use Goal Seek in Excel 2016, 20 to get the formula result you want by changing an input value.
0 kommentar(er)
