Goal Seek Excel Free By Whitelisting

She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies.

Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.

In this example, well find the interest rate for a 100,000 loan with a term of 180 months.

Its in the Microsoft Office group, which youll find in the All Apps area of the Start menu in Windows, and the Applications folder on macOS.

In this example, imagine you want to borrow 100,000 from a bank.

Well use the PMT function because it calculates the payment amount.

Until then, Excel assumes the value is 0, so the result of the formula is 555.56.

Now that youve entered the example data, you can run the Goal Seek tool.

Its in the Data Tools section of the ribbon bar at the top of Excel.

Youre typing B4 because thats where you typed the PMT formula youre resolving.

In the example, you want to pay 900 per month, which is why youre entering it into this box.

This is the empty cell, which is where the result of the Goal Seek tool will appear.

Goal Seek Excel Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

Goal Seek For Mac Excel