How to Use Goal Seek in Excel: A Step-by-Step Guide and Video

How to use Goal Seek in Excel is one of the most useful things you can learn in a spreadsheet, because it answers a question that comes up constantly in business planning, budgeting, and financial modeling: you know the answer you need, but you have to work backwards to find the input that gets you there.

Without Goal Seek, most people guess. They type a number, check the result, nudge the number up or down, and repeat until the formula lands close enough. Goal Seek does that work for you. You tell Excel the result you want and which cell it is allowed to change, and it finds the answer in seconds, usually more precisely than you would by hand.

This guide explains what Goal Seek does, when to use it, and exactly how to run it in five steps, followed by three worked examples, tips for avoiding the common errors, and a free Goal Seek calculator that solves the same problems right on this page and shows you the exact settings to use in Excel.

What Is Goal Seek in Excel?

Goal Seek is a what-if analysis tool built directly into Excel. It works by reversing the normal direction of a calculation. Usually you enter inputs, a formula processes them, and a result appears. Goal Seek flips that around. You start with the result you want, tell Excel which single input it may adjust, and Goal Seek changes that input over and over, recalculating each time, until the formula produces your target.

Here is a simple way to picture it. Say you have a loan payment formula that calculates your monthly payment from the loan amount, the number of payments, and the interest rate. Normally you would type in an interest rate and see what payment comes out. With Goal Seek, you ask the question the other way: "I can afford a payment of exactly $2,000 a month. What interest rate makes that happen?" Excel then finds the rate for you.

That reverse direction is what makes Goal Seek so practical. Real business questions are often framed around a target, such as a payment you can afford, a profit you need, or a savings balance you want to reach, and Goal Seek lets you answer them with the formulas you already have. If you prefer to watch before you read, you can see how to use Goal Seek in this short video.

When Should You Use Goal Seek?

Goal Seek is the right tool any time you know the result you need and want to find the one input value that produces it. A few situations come up again and again in business.

Break-Even Analysis

You want to know exactly how many units you need to sell before revenue covers your costs. Instead of trying 350, then 380, then 410, Goal Seek finds the precise break-even volume in one step, which you can then round up to a whole unit.

Loan and Interest Calculations

You know the monthly payment your budget can handle. Goal Seek can tell you the interest rate, the loan amount, or the number of payments that keeps you within that limit, which is useful when comparing lender offers or deciding how much equipment you can afford to finance.

Sales and Revenue Targets

You need to hit a specific revenue number this quarter. If your forecast is built on formulas, Goal Seek can tell you how many units you need to sell, or what price you need to charge, to reach it.

Savings Goals

You want to have a specific amount saved by a specific date, for example for a vehicle, a tax payment, or a cash reserve. Goal Seek tells you exactly how much to set aside each month, taking interest into account.

Profit Margin Targets

You have a margin in mind and a known cost. Goal Seek tells you what price to charge to reach that margin, or what cost you would need to hit at your current price.

The one requirement across all of these is that the problem involves a single unknown input and a single target output, connected by a formula. As Microsoft's own Goal Seek guide puts it, Goal Seek works with only one variable input value. If you need to adjust several inputs at the same time, or set limits on them, use Excel's Solver add-in instead, which is covered later in this guide.

Where to Find Goal Seek in Excel

Goal Seek is built into Excel and does not require any installation or add-ins. To open it, click the Data tab on the ribbon, then click What-If Analysis, and choose Goal Seek from the menu that drops down. In most current versions, What-If Analysis sits in the Forecast group toward the right side of the Data tab, and the same Data, What-If Analysis, Goal Seek path works in Excel for Mac.

If you cannot find the What-If Analysis button, your ribbon may have been customized, or the Excel window may be narrow enough that the ribbon has collapsed its groups into smaller buttons. Widening the window usually brings it back. In very old versions of Excel that use menus instead of a ribbon, Goal Seek is under the Tools menu.

Step 1: Set Up Your Spreadsheet

Before you open Goal Seek, your worksheet needs three things in place. The first is an input cell holding the value you want Excel to adjust. The second is a formula cell that uses that input to calculate a result. The third is a specific target value you want that formula to reach. Goal Seek cannot work on a value that is not connected to the formula, so the formula must refer to the input cell, either directly or through other formulas.

To follow along, open a blank sheet and type the loan example below into columns A and B.

Loan example: type this into a blank sheet

In this layout, B1 holds the loan amount of $100,000 and B2 holds the number of monthly payments, 60. B3 is the input cell, the annual interest rate that Goal Seek will adjust. B4 is the formula cell, which calculates the monthly payment with =PMT(B3/12, B2, -B1). The formula divides the annual rate by 12 to get a monthly rate, uses the total number of payments, and enters the loan amount as a negative number so the payment comes out positive.

The target in this example is a monthly payment of $2,000. Before you run Goal Seek, it is worth a quick sanity check that the target is possible. At 0% interest, $100,000 over 60 payments is $1,666.67 a month, so no interest rate can produce a payment lower than that. A target of $2,000 is comfortably above that floor, so Goal Seek will find an answer.

The starting value in B3 does not need to be correct. It is simply the point from which Goal Seek begins searching. A reasonable estimate that is close to what you expect, such as 5%, helps Goal Seek find the solution faster and makes it less likely to wander off toward an odd answer.

Step 2: Open Goal Seek

With your worksheet ready, click the Data tab, click What-If Analysis, and then click Goal Seek. It helps to click the formula cell, B4 in this example, before you open the dialog, because Excel fills that cell into the first field automatically.

The Goal Seek dialog box opens with three fields: Set cell, To value, and By changing cell. Each one has a specific job, and all three need to be filled in correctly for Goal Seek to work.

Step 3: Configure Your Goal Seek Settings

Set Cell

Set cell is the cell that contains your formula, the one whose result you want to reach a specific value. In the loan example this is B4, the PMT formula that calculates the monthly payment. Click inside the Set cell field, then click B4 on the worksheet, and the reference appears in the field for you.

To Value

To value is the target result you want the formula to produce. For a monthly payment of $2,000, type 2000. Enter the number only, without dollar signs, commas, or percent signs. If your target is a percentage, such as a 40% margin, type it as a decimal, 0.4.

By Changing Cell

By changing cell is the input cell Goal Seek is allowed to adjust. In the loan example this is B3, the interest rate. Click inside the By changing cell field, then click B3 on the worksheet. This cell must contain a plain value, not a formula, because Goal Seek replaces whatever is in it.

When all three fields are filled in, the dialog box holds these settings for the loan example.

Goal Seek settings for the loan example

Before you click OK, check the fields once more. The most common mistake is putting the same cell in both Set cell and By changing cell, or putting the formula cell in By changing cell. Set cell must always be the formula. By changing cell must always be an input that the formula depends on.

Step 4: Run Goal Seek

Click OK. Excel starts adjusting the value in B3, recalculating the PMT formula after each change, and homes in on the interest rate that produces a payment of $2,000. On a simple worksheet this takes a fraction of a second.

When Goal Seek finds a solution, the Goal Seek Status box appears and tells you that it found one, showing the target value and the current value it reached. At this point you have two choices. Click OK to accept the solution, and Excel keeps the new value in B3 and the updated result in B4. Click Cancel to reject it, and Excel restores your original values as if Goal Seek had never run.

Step 5: Review Your Result

After you click OK, look at B3. It now holds the interest rate that produces a $2,000 monthly payment on a $100,000 loan over 60 months, which is about 7.42%. If the cell shows a long decimal such as 0.0742, format it as a percentage to make it easier to read.

Check B4 as well. It should show $2,000 or something extremely close to it, such as $1,999.99. Goal Seek works by repeated approximation and stops once the result is within a very small distance of your target, so tiny differences from rounding are normal. The answer is accurate for all practical purposes.

If Goal Seek reports that it could not find a solution, there are three usual causes. The target may be mathematically impossible for your formula, like asking for a payment below the 0% floor described in Step 1. The starting value in the By changing cell may be so far from the real answer that Goal Seek gives up before it gets there. Or the formula itself may contain an error that stops it from calculating. Check the formula first, then change the starting value to something closer to what you expect and run Goal Seek again.

Try It: Free Goal Seek Calculator

Use the calculator below to solve the most common Goal Seek problems right on this page. Pick a question, enter your numbers, and it finds the answer, tells you whether the target is possible, and shows the exact Set cell, To value, and By changing cell settings to use in Excel. Copy to Excel gives you a ready-made worksheet with the live formula already in place.

Practical Examples of Goal Seek in Excel

The same five steps work for any single-input problem. Here are three more examples you can build in a few minutes and adapt to your own numbers.

Example 1: Monthly Savings Goal

Suppose you want to have $30,000 saved in 36 months, and your savings account earns 2% annual interest. The question is how much you need to deposit each month.

Savings example: type this into a blank sheet

The layout above puts the number of months and the annual rate in B2 and B3, a starting guess for the monthly deposit in B4, and a future value formula in B5, such as =FV(B3/12, B2, -B4), which shows what the account will hold after the last deposit. Then run Goal Seek with Set cell B5, To value 30000, and By changing cell B4. Goal Seek adjusts the deposit until the balance reaches $30,000 and returns a monthly deposit of about $809.28. Without any interest the answer would be $833.33, so the interest does about $24 a month of the work for you.

Example 2: Break-Even Sales Volume

Your fixed costs are $12,000 a month, and each unit you sell brings in $30 of gross profit after its direct costs. How many units do you need to sell to break even?

Break-even example: type this into a blank sheet

The layout above holds the fixed costs and profit per unit in B1 and B2, a starting guess for units sold in B3, and in B4 calculate profit with a formula that multiplies units by profit per unit and subtracts the fixed costs. Then run Goal Seek with Set cell B4, To value 0, and By changing cell B3. Setting profit to zero is what defines break-even, and Goal Seek returns exactly 400 units. Every unit you sell beyond 400 adds $30 to your profit.

This example is simple enough to check by hand, since $12,000 divided by $30 is 400, but the value of Goal Seek shows up once the worksheet grows. When profit depends on discounts, commissions, and volume-based costs spread across many formulas, dividing by hand stops working, while Goal Seek still finds the answer the same way.

Example 3: Required Selling Price for a Target Margin

You want every unit you sell to earn a 40% gross margin. Each unit costs you $45 to make or buy. What price do you need to charge?

Pricing example: type this into a blank sheet

The layout above holds the unit cost in B1, a starting guess for the price in B2, and in B3 calculate the margin as price minus cost, divided by price. Then run Goal Seek with Set cell B3, To value 0.4, and By changing cell B2. Goal Seek returns a selling price of $75, because $75 minus $45 leaves $30, and $30 is 40% of $75.

This is also a good reminder of the difference between margin and markup. A 40% margin requires a 66.7% markup on cost, not 40%. Pricing at cost plus 40%, which would be $63, only produces a margin of about 28.6%. Letting Goal Seek solve for the price avoids that mistake entirely.

Tips for Getting the Best Results From Goal Seek

Start With a Reasonable Estimate

The value in your By changing cell before you run Goal Seek is where the search begins. Starting close to the expected answer helps Goal Seek find the solution faster, and it reduces the chance of landing on the wrong answer when a formula has more than one possible solution.

Change One Variable at a Time

Goal Seek can adjust only one input cell per run. If reaching your target requires changing two or more inputs together, or keeping inputs within limits, use Solver instead.

Make Sure Your Formula Works First

If the formula contains an error or produces nonsense with your starting values, Goal Seek will fail. Test the formula by hand with a few sample inputs to confirm it gives sensible results before asking Goal Seek to work with it.

Confirm the Target Is Possible

Goal Seek cannot find a solution that does not exist. A loan payment lower than the 0% payment, a margin of 100% or more, or a savings balance that cannot be reached in the time allowed will all fail. If Goal Seek keeps failing, ask whether the target is achievable given how your formula works.

Protect Your Original Values

Goal Seek overwrites the By changing cell when you accept a solution. If you want to keep the original input, copy it to another cell first. If you click Cancel in the Goal Seek Status box, Excel restores the original values for you.

Goal Seek vs. Solver: Which One Do You Need?

Use Goal Seek when you have one formula, one target value, and one input to change. It is fast, simple, and ready to use with no setup. For the large majority of everyday what-if questions, it is all you need.

Use Solver when the problem is bigger than that: when you need to adjust several inputs at once, when those inputs must stay within minimum or maximum limits, or when you want to make a result as large or as small as possible rather than hit a specific number. Solver is an add-in that appears in the Analysis group on the Data tab once it is turned on, and Microsoft's Solver guide explains how to load it if you do not see it.

Using Goal Seek in Google Sheets

Google Sheets does not include Goal Seek as a built-in menu command the way Excel does, but you can get the same result with a free add-on or with a few simple formulas. If you work in both programs, our guide on how to use Goal Seek in Google Sheets walks through both approaches step by step.

Keep Building Your Excel Skills

Goal Seek pairs naturally with the formulas it relies on, such as PMT, FV, and simple profit calculations. Our Excel formulas cheat sheet covers those and dozens more with worked examples, and our free Excel courses and Excel course videos take you from the basics to building complete business tools.

When your planning outgrows spreadsheets, Updoot brings budgets, projects, time tracking, and invoicing into one system as business management software for $5 per user per month, and every report still exports to Excel.