Goal Seek in MS Excel !
Goal Seek In MS Excel !
When you know the desired result of a single formula but not the input value the formula needs to determine the result, you can use the Goal Seek feature available by clicking,
Data —> What-If Analysis —> Goal Seek
When goal seeking, Microsoft Excel varies the value in one specific cell until a formula that’s dependent on that cell returns the result you want.
For example, use Goal Seek to change the interest rate in cell D7 incrementally until the payment value in D8 equals 7,500