How to use Goal Seek function in Microsoft Excel

In this article, we will learn how to use Goal Seek function in Excel 2016.

Goal Seek function is a tool of What-if-analysis used to get the desired output by setting a value in a cell and receiving change in the dependent variable.

I will not confuse you anymore. Let’s understand this with an example here.

Here we have 2 columns:

    • Students name
    • And their scores

58
We need to find the average of the scores.

Use the formula to find the average

=AVERAGE(B2:B10)

69
Here we don’t know the scores of Dan. So we use Goal seek function by setting the overall Average score.

We will set the average to 60.

Go to Data > What-if-Analysis > Goal Seek
70
Goal seek dialog box appears which is like the snapshot shown below.
71
Set Cell: FIxing the cell where the average value which is D2.
To value: The value we are fixing is 60 here.
By changing cell: Dan’s score needs to be matching the overall average which is B10.

Press Ok and you will get Dan’s score.
72
Goal seek function finds a solution and shows with Goal seek Status.

Hope you understood how to use Goal seek function inm Excel 2016. Goal seek function also works in 2010 and 2013 Excel. Find more articles on Goal seek function here. Please share your query below in the comment box. We will assist you.

Related Articles:

 

Popular Articles:

The VLOOKUP Function in Excel

COUNTIF in Excel 2016

How to Use SUMIF Function in Excel

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube