**
What is a Goal Seek
**

Goal Seek is a formula which is used for Reverse Calculation

It can only be used if some formula or links have been used while passing entries

**
How to do?
**

Data-->What-if Analysis--->Goal Seek

For Excel 2003: Tools --> Goal Seek

**
It asks for 3 things
**

**
Set Cell
**
—Select Cell which has old value (This should have formulas)

**
To Value
**
—Put New Value(This should have new value)

**
By Changing
**
-Select Cell where Answer Required (This should not have a formula)

**
Example 1
**

**
**

Download file and try

**
Example 2
**

**
Example 3
**

**
**

**
Example 4
**

**
**

**
**

**
**

**
**

**
Example 5
**
**
**

Solve all your doubts with Teachoo Black (new monthly pack available now!)