How to Use Goal Seek in Google Sheets: A Step-by-Step Guide
How to use Goal Seek in Google Sheets is worth learning if you ever need to work backwards from an answer, because it solves a problem that comes up constantly in budgeting, financial analysis, and business planning: you know the result you want, but you need to figure out which input gets you there.
Without Goal Seek, you would change a number, check the result, change it again, and keep going until you landed close enough. Goal Seek does that trial and error for you. You tell it the result you want and which cell it may change, and it finds the answer automatically, usually in a second or two.
This guide explains what Goal Seek does, when to use it, how to install the free add-on, and how to run it in six steps. It also shows three worked examples, a way to get the same answers with plain formulas and no add-on at all, and a free Goal Seek calculator that solves common problems right on this page.
What Is Goal Seek in Google Sheets?
Goal Seek is a what-if analysis tool that works backwards from a result you want to the input needed to produce it. Most spreadsheet formulas work forward. You enter the inputs, the formula runs, and an output appears. Goal Seek reverses that. You name the output you want, tell Google Sheets which single input it may change, and Goal Seek keeps adjusting that input until the formula produces your target.
A loan is the classic example. Say you have a formula that calculates a monthly payment from the loan amount, the number of payments, and the interest rate. Normally you would type in a rate and see what payment comes out. With Goal Seek, you ask the question the other way around: "I want my monthly payment to be $2,000. What interest rate makes that happen?" Goal Seek then finds the rate.
When Should You Use Goal Seek?
Goal Seek is useful any time you know the result you need and are working backwards to find the input that produces it. A few situations come up constantly for small businesses and anyone managing their own finances.
Financial Planning
If you want to save a set amount by a set date, such as $50,000 in three years for an equipment purchase or a cash reserve, Goal Seek tells you how much to put away each month to get there, with interest taken into account.
Loan Analysis
When you know the monthly payment your budget can handle, Goal Seek can find the interest rate or loan amount that keeps you within it, which makes it easier to compare lender offers side by side.
Sales Targets
If you need to reach a specific revenue number, Goal Seek can tell you how many units you need to sell at your current price, or what price you need at the volume you expect.
Profit Margin Goals
With a target margin in mind, Goal Seek can tell you what price to charge given your costs, so you do not have to rearrange the margin formula by hand.
Break-Even Analysis
Goal Seek finds the exact sales volume at which revenue covers your costs, which tells you the minimum you need to sell before a product, location, or month starts making money.
The key requirement for every one of these is that the problem has one unknown input and one target output, connected by a formula. If you need to adjust several inputs at once, or keep them within limits, look at a Solver add-on instead, which handles optimization with multiple variables.
Important: Goal Seek Is Not Built Into Google Sheets
Before you start, there is one thing to know. Unlike Microsoft Excel, Google Sheets does not include Goal Seek as a built-in menu command. Instead, Google publishes Goal Seek as a free add-on, and you install the Goal Seek add-on from the Google Workspace Marketplace.
Installation takes about two minutes, and you only do it once. After that, Goal Seek appears in your Extensions menu whenever you need it. If you would rather not install anything, the section on solving without the add-on shows how to get the same answers with ordinary formulas.
Step 1: Set Up Your Spreadsheet
Before you install or run Goal Seek, set up the worksheet it will work on. Goal Seek needs three things. The first is an input cell holding the value you want it to change. The second is a formula cell that uses that input to calculate a result. The third is the target result you want the formula to reach. The formula has to depend on the input cell, directly or through other formulas, or Goal Seek has nothing to work with.
Here is a loan payment example.
Loan example: type this into a blank sheet
| Column A (label) | Column B (what to type) | What it does |
|---|---|---|
| A1 Loan amount | 100000 | The amount borrowed |
| A2 Number of payments | 60 | Five years of monthly payments |
| A3 Annual interest rate | 5% | A starting guess that Goal Seek will change |
| A4 Monthly payment | =PMT(B3/12,B2,-B1) | Calculates the payment from the three inputs |
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 number of payments, and enters the loan amount as a negative number so the payment shows as positive.
The target in this example is a payment of $2,000 a month. It is worth checking that a target is possible before you run anything. At 0% interest, $100,000 over 60 payments works out to $1,666.67 a month, so no interest rate can produce a payment below that. A target of $2,000 is above that floor, so Goal Seek will be able to find an answer.
The value you type in B3 now does not have to be right. It is just the starting point for Goal Seek's search. A reasonable estimate, such as 5%, helps it find the answer faster and more reliably.
Step 2: Install the Goal Seek Add-On
Open any Google Sheets file and click the Extensions menu at the top of the screen. Point to Add-ons and click Get add-ons. The Google Workspace Marketplace opens. Type Goal Seek into the search bar at the top and press Enter, then choose the Goal Seek add-on published by Google from the results.
On the add-on's page, click Install. Google shows a permissions screen asking to let the add-on work with your spreadsheets, and you click Allow to continue. When the installation finishes, you see a confirmation message. Close the Marketplace window and return to your sheet. The add-on is now installed on your account, so you will not need to install it again for future files.
Step 3: Open Goal Seek
Click the Extensions menu again. Goal Seek now appears in the list of installed add-ons. Point to it and click Open. A Goal Seek panel opens on the right side of the screen, next to your data, and this is where you set up the calculation.
Step 4: Configure Your Goal Seek Settings
The Goal Seek panel has three fields. Each one matters, and a mistake in any of them produces a wrong answer or no answer at all.
Set Cell
Set cell is the cell containing your formula, the one whose result you want to control. In the loan example this is B4, the PMT formula that calculates the monthly payment. Click in the Set cell field and then click B4 on the sheet, or type B4 directly.
To Value
To value is the target result you want the formula to reach. For a monthly payment of $2,000, type 2000. Leave out dollar signs and commas and enter the number only. If your target is a percentage, type it as a decimal, such as 0.4 for 40%.
By Changing Cell
By changing cell is the input Goal Seek is allowed to adjust. In the loan example this is B3, the interest rate. Click in the field and then click B3, or type B3. This cell should hold a plain number, not a formula, because Goal Seek will replace its contents.
With all three fields filled in, the panel holds these settings for the loan example.
Goal Seek settings for the loan example
| Goal Seek field | What to enter |
|---|---|
| Set cell | B4 |
| To value | 2000 |
| By changing cell | B3 |
| Then | Click Solve. B3 changes to about 7.42%. |
Double-check the three fields before you continue. The most common mistake is entering the same cell in both Set cell and By changing cell, or putting the formula cell in By changing cell. Set cell is always the formula, and By changing cell is always an input the formula depends on.
Step 5: Run Goal Seek
Click the Solve button in the Goal Seek panel. The add-on starts trying values for the interest rate in B3, recalculating the PMT formula each time, until the payment in B4 matches $2,000. For a simple worksheet like this one, the process takes a second or two, and more complex sheets may take a little longer.
When it finishes, Goal Seek writes the answer into your By changing cell, B3, and the formula in B4 updates to match. The panel also includes options for the maximum number of iterations, the tolerance, meaning how close to the target is close enough, and a time limit. The default settings work for most problems, but raising the limits can help with complicated formulas.
Step 6: Review and Interpret Your Result
Look at B3. It now holds the interest rate that produces a payment of $2,000 on a $100,000 loan over 60 months, which is about 7.42%. If it shows a decimal such as 0.0742, use Format, Number, Percent to display it as a percentage.
Check B4 too. It should show $2,000 or a value extremely close to it, such as $1,999.99. Goal Seek works by repeated approximation and stops once it is within its tolerance of the target, so a tiny difference from rounding is normal. The result is accurate enough for any practical purpose.
If Goal Seek does not find a solution, there are three usual causes. The target may be impossible for your formula, such as a payment lower than the 0% floor from Step 1. The starting value in the By changing cell may be too far from the real answer for Goal Seek to get there within its limits. Or the formula may contain an error that stops it from calculating. Check the formula, move the starting value closer to what you expect, and run it again.
Try It: Free Goal Seek Calculator
If you want an answer right now, or want to check the add-on's result, use the calculator below. Pick the question, enter your numbers, and it solves the problem, warns you if the target is impossible, and shows the exact Set cell, To value, and By changing cell settings for the Goal Seek add-on. Copy to Sheets gives you the worksheet with the live formula already in place.
Goal Seek Calculator
Pick the question you want answered and enter your numbers. The calculator solves it the same way Goal Seek does, warns you if the target is impossible, and shows the exact settings to use in Google Sheets. Copy to Sheets gives you the worksheet with the live formula in place. Nothing you enter is saved or sent anywhere.
Build It in Google Sheets
| Cell | Label (column A) | Column B |
|---|
Practical Examples of Goal Seek in Google Sheets
Once you have run Goal Seek once, the same steps work for any single-input problem. Here are three more examples to build and adapt.
Example 1: Monthly Savings Goal
You want to save $20,000 in 24 months, and your savings account earns 3% annual interest. How much do you need to save each month?
Savings example: type this into a blank sheet
| Column A (label) | Column B (what to type) | What it does |
|---|---|---|
| A1 Savings goal | 20000 | For reference only |
| A2 Number of months | 24 | How long you have to save |
| A3 Annual interest rate | 3% | What the account earns |
| A4 Monthly deposit | 500 | A starting guess that Goal Seek will change |
| A5 Balance at the end | =FV(B3/12,B2,-B4) | What the account will hold after the last deposit |
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 the balance after the last deposit. Then open Goal Seek and set Set cell to B5, To value to 20000, and By changing cell to B4. Goal Seek finds a monthly deposit of about $809.62. Without interest you would need $833.33 a month, so the interest covers roughly $24 of each deposit.
Example 2: Break-Even Units
Your fixed costs are $15,000 a month, and each unit you sell generates $25 of gross profit. How many units do you need to sell to break even?
Break-even example: type this into a blank sheet
| Column A (label) | Column B (what to type) | What it does |
|---|---|---|
| A1 Fixed costs per month | 15000 | Rent, salaries, and other costs that do not change with sales |
| A2 Gross profit per unit | 25 | What each sale adds after its direct costs |
| A3 Units sold | 100 | A starting guess that Goal Seek will change |
| A4 Profit | =B3*B2-B1 | Profit after fixed costs |
The layout above holds the fixed costs and profit per unit in B1 and B2, a starting guess for units in B3, and a profit formula in B4 that multiplies units by profit per unit and subtracts fixed costs. Run Goal Seek with Set cell B4, To value 0, and By changing cell B3. Because break-even is simply the point where profit is zero, Goal Seek returns 600 units. Every unit beyond that adds $25 to your profit.
Example 3: Target Revenue Price
You need to generate $50,000 in revenue this month and expect to sell 320 units. What price do you need to charge?
Revenue example: type this into a blank sheet
| Column A (label) | Column B (what to type) | What it does |
|---|---|---|
| A1 Units you expect to sell | 320 | Your sales forecast for the month |
| A2 Price per unit | 100 | A starting guess that Goal Seek will change |
| A3 Revenue | =B2*B1 | Units times price |
The layout above holds the expected units in B1, a starting guess for the price in B2, and a revenue formula in B3 that multiplies price by units. Run Goal Seek with Set cell B3, To value 50000, and By changing cell B2. Goal Seek returns $156.25 per unit, since 320 units at $156.25 comes to exactly $50,000.
These last two examples are simple enough to check with a single division, and that is a good way to confirm you have set Goal Seek up correctly the first time you use it. Its real value appears when the result depends on a long chain of formulas, such as revenue after discounts, fees, and commissions, where working backwards by hand stops being practical.
How to Solve Without the Add-On
For many common questions, Google Sheets already has a function that answers them directly, with no add-on and no iteration. These are worth knowing because they update instantly whenever your inputs change, while Goal Seek writes a fixed answer that you have to rerun.
To find the interest rate for a target payment, the RATE function works backwards for you. =RATE(60, -2000, 100000)*12 returns the same annual rate of about 7.42% that Goal Seek found in the loan example. To find the monthly deposit for a savings goal, use PMT with the goal as a future value: =PMT(3%/12, 24, 0, -20000) returns about $809.62. For break-even units, divide fixed costs by profit per unit, and for a revenue target, divide the target by the units you expect to sell.
Goal Seek is still the better tool when there is no ready-made function for your question, or when the answer depends on a whole model of linked formulas. For everyday loan, savings, and pricing questions, though, a direct formula is often the faster route.
Tips for Getting the Best Results From Goal Seek
Start With a Reasonable Estimate
The value in your By changing cell before you click Solve is where Goal Seek starts searching. Starting near the expected answer helps it finish faster and makes it more likely to find the right answer when a formula could have more than one.
Change One Variable at a Time
Goal Seek can only adjust one input cell per run. If you need to change two or more inputs together to hit a target, a Solver add-on is the right tool.
Make Sure Your Formula Works First
If the formula has an error or gives nonsense with your starting values, Goal Seek cannot find a valid solution. Test the formula with a few sample inputs before you run it.
Check That the Target Is Possible
Goal Seek cannot find an answer that does not exist. A payment below the 0% floor, a margin of 100% or more, or a savings goal that cannot be reached in the time given will all fail. If Goal Seek keeps failing, ask whether the target is realistic.
Keep a Copy of Your Original Values
Goal Seek overwrites your By changing cell with the solution. Copy the original value somewhere else first if you want to keep it, or use Edit, Undo right after Goal Seek runs to put it back.
Goal Seek vs. Solver: Which Should You Use?
Goal Seek is the right tool when you have one unknown input and one target output. It is quick, simple, and needs nothing beyond the three fields covered above. For most everyday what-if questions, it is all you need.
A Solver add-on is the right tool when you need to adjust several inputs at once, keep those inputs within limits, or find the largest or smallest possible result instead of a specific target. Solver add-ons for Google Sheets are available from the Workspace Marketplace. They take longer to set up but handle problems Goal Seek cannot, such as staff scheduling, product mix, or dividing a budget across channels.
| Question | Goal Seek | Solver |
|---|---|---|
| How many inputs can change? | One | Many |
| Can you set limits on inputs? | No | Yes, with constraints |
| What does it aim for? | An exact target value | A target, a maximum, or a minimum |
| Setup needed | Install the free add-on once | Install an add-on and define the model |
If you also work in Excel, where Goal Seek is built in, our guide on how to use Goal Seek in Excel covers the same process there.
Keep Building Your Spreadsheet Skills
Goal Seek is only as useful as the formulas behind it. Our formulas cheat sheet covers PMT, FV, and dozens of others that work the same way in Google Sheets, and our free Excel courses walk through building complete business tools in a spreadsheet.
When the spreadsheets start running the business, Updoot brings budgets, projects, time tracking, and invoicing into one place as business management software for $5 per user per month.
Opens in Google Drive. View and download for free.
Frequently Asked Questions About Goal Seek in Google Sheets
Does Google Sheets have Goal Seek built in?
No. Google Sheets does not include Goal Seek as a built-in command. Google offers it as a free add-on. Go to Extensions, Add-ons, Get add-ons, search for Goal Seek, and install it. You only need to do this once.
What is Goal Seek used for in Google Sheets?
Goal Seek finds the input value needed for a formula to produce a specific result. Common uses include finding the interest rate for a target loan payment, the sales volume needed to break even, the monthly savings needed to reach a goal, and the price needed to hit a revenue or margin target.
Why is my Goal Seek not finding a solution?
The usual reasons are that the target is impossible for your formula, the starting value in the By changing cell is too far from the answer, or the formula contains an error. Check the formula, move the starting value closer to the expected answer, and try again. You can also raise the iteration and time limits in the add-on's options.
What is the difference between Goal Seek and Solver in Google Sheets?
Goal Seek changes one input to reach one exact target. A Solver add-on can change several inputs at once, keep them within limits, and find a maximum or minimum. Use Goal Seek for simple one-variable questions and Solver for larger optimization problems.
Can Goal Seek work with any formula in Google Sheets?
Goal Seek works with any formula whose result depends on the cell you ask it to change. It works best when small changes in the input cause smooth changes in the result. It can struggle with formulas that use IF statements or rounding that make the result jump, or that return the same result across many inputs.
Is the Goal Seek add-on for Google Sheets free?
Yes. The Goal Seek add-on from Google is free to install and use from the Google Workspace Marketplace.
How accurate is Goal Seek in Google Sheets?
Goal Seek stops when the result is within a small tolerance of your target, so you may see $1,999.99 instead of $2,000. That is accurate enough for practical business and financial calculations, and you can tighten the tolerance in the add-on's options if you need more precision.
Can I get Goal Seek answers without the add-on?
Often, yes. Functions such as RATE, PMT, and NPER answer common loan and savings questions directly, and simple division handles break-even and revenue targets. Goal Seek is most useful when no single function answers your question.