Goal seek in Excel

Goal Seek is another tool under "What If" analysis that does a unique function as Scenario Manager.

In Scenario Manager, we predicted the outcomes of various possible Input combinations.

For example, we predicted the Profit of a company based on various assumptions of Sales and Expenses.

The Goal Seek, unlike Scenario Manager, does the exact reverse.

What if one has the desired output, for example, say the same company wants to achieve $80,000 profit,

but don't know the input values, in this case, sales and expenses?

This is where "Goal Seek" comes for help.

Here, we set the desired output and predict the possible input combinations to achieve this.

This is illustrated in the following exampe.

excel goal seek

From the above example, let us assume that the company has decided to spend $75,000 as expense but want to achieve $80,000 as profit.

Now, let us see how Goal Seek helps with this.

Goto "What If" and Select "Goal Seek"

excel goal seek

The following window appears

excel goal seek

Here, Set Cell refers to the Profit/Loss cell and "Set Value" refers to the desired value to be obtained, in this case, the company wants a profit of $80,000.

"By Changing Cell" refers to "Sales" value, which is A13.

When OK is clicked, the output is shown in the cell A13; that is total sales amount required to achieve the desired profit of $80,000.

excel goal seek


You can find similar Excel Questions and Answer hereunder

1) How do I restrict user entry in ActiveX Text Box to just numeric values?

2) I have angle values in radians. In Excel, how can I convert them to degrees?

3) How can I plot 2 series on the same chart with different scales / measurement unit for Values (Ex: Pareto chart)?

4) How to get user input in VBA with the inputbox function

5) How can I convert Column numbers into Column names for use in range definition?

6) Determine if hyperlinks are valid in Excel

7) How do I get the principal part of loan payment for the year given Loan amount, Rate of Interest and period?

8) The scenario manager in Excel VBA allows to explore various scenarios in a very easy way

9) How to do workbook protection with VBA in Excel

10) How to protect your workbook in Excel


Here the previous and next chapter