1. Home
  2. MS Office

Goal Seek In Excel 2010

Excel 2010 includes different techniques of Data Analysis, Goal Seek is a technique used to find out the ambiguous number, or which you are not sure of. This technique is very useful especially when you are dealing with big numbers in datasheet, as the name implies it will seek the goal for you in complex situations. This feature allows you to alter the data used in a formula in order to find out what the results will be. The different results can then be compared to find out which one best suits your requirements.

For demonstration purpose, we have included brief datasheet just to elaborate the usage of Goal Seek. We have three row labels; Number, Multiplied by, and Result.

goal seek

Now we want to find out the number which when multiplied with Number data (2342), shows desired result lets say;

2342 * ? = 60,000

For that we need to write simple Multiplication formula in Result adjacent cell.


result zero `

Now we will find out number that when multiplied with B2 (2342) gives us 60,000, for that switch to Data tab, from What-if Analysis drop-down options click Goal Seek.

goal seek button 1

You will see dialog asking for select cells, in Set cell we need to select the cell which contains the formula, in To value we need to enter desired number and in By Changing Cell we need to select the cell which will be changed.

select cell 1

In our case, we will select B4 cell for Set Cell that actually contains formula. In To Value we enter value 60000, and in By Changing cell we select B3 where result will be placed. Click OK to continue.

result goal seek 1

Goal Seek Status will appear showing the Target and Current value, along with that Excel shows the result in cell B3 (Multiplied by) that we required.

result notify 1

Leave a comment