Goal Seek in MS Excel !

Spread the love

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

Author: wehelpf9