Check sibling questions

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)
Goal Seek Assignment.xls

Example 2

Example 3


Example 4


Example 5

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.