<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

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

Use of Goal Seek Formula - Goal Seek

 

 Download file and try

 
(For Excel 97, 2003, 2007)
 
 

Example 2

Example 3

 

Example 4

 

Example 5

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
Didn't understand? Ask your question or doubt free.

Apna sawal puchiye!

Jail