How to use the Goal Seek Feature
This tutorial demonstrates how to to use the goal seek feature in Excel.

This spreadsheet calculates monthly loan payments.


Each Amount is an entered value.


The Payment is calculated using the three entered values.


A lower interest rate would lower the monthly payment.


If we wanted a montly payment of $900, we could keep adjusting the rate by trial and error, or we could use the Goal Seek Tool.


The Goal Seek function will set a calculated cell to a desired value by adjusting an entered value.


Set Cell is highlighted.


Click the Payment formula.


Cell B4 has been indicated.


Move to the To Value field.


...and enter the desired payment amount of -900.


Now move to the By Changing Cell field.


...and select the Rate cell as the value to change.


Cell B3 has been selected.


Click OK to run.


The Target Value has been reached by adjusting the rate to 7.02%.


Click OK to accept these terms.


Back to Top
sign up for
our newsletter
Name:
Email:

Want to order our products?
Click Here to place and order.

All Material on this website © 2008 Overnight Genius Privacy Policy | Terms of Use
Microsoft® is a registered trademark of Microsoft Corporation in the United States and/or other countries. All trademarks and registered trademarks contained herein are the property of their respective owners. Microsoft® has not endorsed the products sold by Overnight Genius™.
Home
Contact Us
Site Map
Microsoft Excel Tutorials Microsoft Word Tutorials
Choose a Tutorial: Excel Keyboard Shortcuts How to Print Gridlines Goal Seek Feature