Skip to main content

Goal Seek feature in Excel


Have you ever found yourself plugging in successively higher and lower values into an input cell, hoping to arrive at a certain answer?


A tool that is built in to Excel does exactly this set of steps. Select the cell with the Payment formula. On the Data tab, in the Data Tools group, look for the What-If Analysis dropdown and choose Goal Seek….

A simple model calculates a loan payment. Choose the payment cell.
Under What-If Analysis, choose Goal Seek.

The figure below shows how you can try to set the payment in B5 to $425 by changing cell B1

In the Goal Seek dialog, Set Cell B5 to $425 by changing cell B1.

Goal Seek finds the correct answer within a second.

Excel quickly finds that you can get to a $425 car payment if you can get to a $22,384.9 car price.

Note that the formula in B5 stays intact. The only thing that changes is the input value typed in B1.

Also, with Goal Seek, you are free to experiment with changing other input cells. You can still get the $425 loan payment and the $25,995 car if your banker will offer you a 71.3379-month loan!

You can Goal Seek based on other cells. Set the Payment to $425 by changing the term and you need a 71.3379 month loan.
Labels:

Comments

Post a Comment

Popular posts from this blog

Find Largest Value in Excel

MAXIFS One of the new Office 365 functions added in February 2016 is the MAXIFS function. This function, which is similar to SUMIFS, finds the largest value that meets one or more criteria: You can either hard-code the criterion as in row 7 below or point to cells as in row 9. A similar MINIFS function finds the smallest value that meets one or more criteria. While most people have probably heard of MAX and MIN, but how do you find the second largest value? Use LARGE (rows 2 and 3) or SMALL (rows 4 and 5). What if you need to sum the top seven values that meet criteria? The orange box below shows how to solve with the new Dynamic Arrays. The green box is the  Ctrl+Shift+Enter  formula required previously.
Post a Comment
Read more

Introduction to Power BI and Power BI Desktop

  Introduction to Power BI and Power BI Desktop 1. What is Power BI 2. Power BI Desktop Installation 3. Power BI Desktop User Interface Power BI Desktop Installation Link https://www.microsoft.com/en-us/download/details.aspx?id=58494 Please Subscribe the Channel for Updates on new Tutorial videos https://www.youtube.com/channel/UCW_euuHC79CPXuwUDoqT5Rg Books https://www.amazon.in/Punit-Prabhu/e/ ... Business/Consulting/Corporate /Individual Training solutionsformso@gmail.com
Post a Comment
Read more

Power Bi Vs Tableau - Which BI tool to choose

 Power Bi  Vs  Tableau - Which BI tool to choose Both Power BI and Tableau are almost similar in features with major difference in user interface. Selection of any BI tool depends on below points 1. Cost 2. User Friendly 3. Data Import options  4. Sharing Dashboards 5. Computing Power of Big Data 6. Support in form of  in app tools / Knowledge sharing / Queries solving / Tutorial / Reference materials 7. Software used in a organization, Microsoft apps or G-suite (google). If in an organization Microsoft apps are used then Power BI should be used as a BI tool because it has all the integrations built in to other Microsoft apps. Power BI is a business analytics service provided by Microsoft that can analyze and visualize data, extract insights, and share it across various departments within your organization. While Tableau is a powerful Business Intelligence tool that manages the data flow and turns data into actionable information. It can create a wide range of d...
Post a Comment
Read more