This is the cell we want to change in order to impact the “set cell.” By changing cell–In this box, enter the reference of the input cell (variable) to be adjusted.This is the value of the “set cell” to be attained.
This is the target cell or the formula cell. The parameters to be specified in the “Goal Seek” dialog box are stated as follows: Goal seek function in excel is used in financial modeling and forecasting scenarios. This is why it is helpful in cause and effect analysis. It shows the impact of change in one value on the other value. The Goal Seek changes the variable (cause) to study the variations in the result (effect). The Goal Seek function can determine the number of units of the product to be sold to achieve the given target of $50,000. In other words, the tool helps answer the question, “what should be the value of the input in order to attain the given output?”įor example, the cost price of a product is $15 and the business wants to earn revenue of $50,000. The Goal Seek in excel is a “what-if-analysis” tool that calculates the value of the input cell (variable) with respect to the desired outcome.
