Goal Seek On Excel How To Use Goal

It comes under the What If Analysis feature of Microsoft Excel, which is useful to find out the value that will give the desired result as a requirement.

This function instantly calculates the output when the value is changed in the cell.

You have to mention the result you want the formula to generate, and then determine the set of input values that will generate the result.

Let understand the working of Goal Seek in Excel by Some Examples.

So the Profit value (Revenue Fixed Cost Variable cost) needs to be zero to attain break-even value.

He has been told that the loan amount will be sanctioned at an interest rate of 10 per annum for a period of 45 months, which makes the repayment of Rs 481.32 per month.

When he calculated the total amount, which he will be repaid in 45 months, he got Rs 21659.47 as a result.

So to find out the return, the person uses the FV function (procedure of calculation is shown in the above figure).

He wants to find the interest rate which will help him to attain the desired return.

Goal Seek On Excel How To Use Goal

Here we discuss its uses and how to use Goal Seek in Excel with excel examples and downloadable excel templates.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Goal Seek On Excel For Mac