# 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.*

** **

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.

=(B2*B3)

* *

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.*

* *

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.

* *

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.

*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.

#### Leave a comment

- boizzie cole
- Geoff
- Kathy

- fa
- AMBER

- gangsta rio
- james.marsh
- banti