Goal Seek in Google Sheets: Find a Target Value Fast

Google Sheets does not offer a built-in Goal Seek command like Excel, but you can use a Goal Seek add-on to make a formula reach a chosen result by changing one input cell. Set the formula cell, target value, and cell to adjust; for example, a profit formula can show how many units you need to sell to reach a specified profit target.

What Goal Seek means in a spreadsheet

Goal Seek is a type of what-if analysis. You start with a formula whose result depends on an input, choose the result you want, and let a solver search for an input value that produces it. Instead of repeatedly changing an assumption by hand, you ask the spreadsheet to work backward from the answer.

For instance, a worksheet might calculate monthly profit from selling price, unit cost, fixed costs, and units sold. If you already know the profit target, Goal Seek can estimate the number of units required, while leaving the other inputs unchanged. The formula remains in place; the solver changes the selected input cell.

It is different from typing a result into a cell or using a regular formula to calculate an answer. The target is a condition to satisfy, and the tool searches for a value that makes the existing formula meet that condition. This is useful when the relationship is inconvenient to rearrange algebraically, or when a formula has several steps.

Does Google Sheets have built-in Goal Seek?

Google Sheets in a web browser does not have a native Goal Seek command in its standard menus. The usual approach is to add a Goal Seek extension from Google Workspace Marketplace. Availability, the interface, and the permissions requested can change, so check the current listing and its publisher before installing. Do not assume that every add-on with a similar name is made by Google.

To look for one, open the spreadsheet and choose Extensions > Add-ons > Get add-ons. Search the Marketplace for Goal Seek, review the listing, and install a suitable add-on if your account permits it. After installation, look under Extensions for its menu entry and follow the add-on’s own instructions. Organizations may restrict Marketplace installations, in which case an administrator may need to approve the tool.

An add-on can request access to spreadsheet data or other account permissions to do its work. Review those permissions and your organization’s rules before granting access, particularly if the workbook contains personal, customer, payroll, or confidential business information. If you cannot or do not want to install an add-on, use the manual alternatives below.

A worked example: target profit

Suppose a small business worksheet uses an illustrative selling price of $25 per unit, a variable cost of $10 per unit, and fixed costs of $3,000. The target is $6,000 in profit. In this simplified model, profit is the contribution per unit multiplied by quantity, minus fixed costs. The values are only an example, not financial, tax, investment, or legal advice; use verified assumptions and consult a qualified professional when appropriate.

Set up the cells as follows: B2 contains the selling price, 25; B3 contains the variable cost per unit, 10; B4 contains fixed costs, 3000; and B5 contains a starting quantity, such as 100. Put the profit calculation in B6. With selling price in B2, unit cost in B3, fixed costs in B4, and quantity in B5, enter this formula in B6:

=(B2-B3)*B5-B4

At the starting quantity of 100, the formula returns -1500: the $15 contribution per unit multiplied by 100 is $1,500, and subtracting $3,000 in fixed costs gives a loss of $1,500. To find the quantity that produces $6,000, tell the Goal Seek add-on to set B6 to 6000 by changing B5. The result should be 600 units: $15 multiplied by 600 is $9,000, and $9,000 minus $3,000 is $6,000.

This example has a simple linear relationship, so it can also be solved by hand. Goal Seek becomes especially useful when the formula is longer, includes several calculations, or is awkward to rearrange. The result is still only as meaningful as the inputs and assumptions in the sheet.

How to run Goal Seek in Google Sheets

After installing an add-on, the exact panel labels and steps depend on that add-on. In general, identify the formula cell, the target result, and the one input cell the solver is allowed to change. For the example above, those are B6, 6000, and B5 respectively. Then run the solve operation and inspect the changed input and recalculated formula.

Make a copy of the sheet or record the original input value so you can restore it.
Check that the formula cell calculates correctly before using the solver. Confirm that it references the intended input cell.
Open the Goal Seek add-on from the Extensions menu and select the formula or result cell it asks you to set.
Enter the desired target value, such as 6000, and identify the single cell to change, such as B5.
Run the calculation, then check whether the solver reports success and whether the new input is plausible.
Verify the result in the sheet. If the answer is fractional but the real-world input must be a whole number, decide how to handle that constraint rather than assuming the raw result is usable.

Some add-ons display a side panel; others use a dialog or provide a completion message. Their labels can differ, so treat the selected cells and target as the important concepts rather than expecting every screen to look identical. If a result seems wrong, undo or restore the input and check the setup before trying again.

What the solver is doing

A Goal Seek tool repeatedly changes the input and recalculates the formula, looking for a result close to the target. It is a numerical search, not a guarantee that a useful or unique answer exists. For a simple steadily increasing formula, the search may be straightforward. For formulas with thresholds, rounding, lookup logic, or several peaks and dips, a solver may have difficulty or find a solution that is not the one you expected.

Most Goal Seek tools work with one changing cell and one target formula at a time. That makes them suitable for questions such as “what price produces this revenue?” or “what quantity gives this profit?” They are not designed to choose many inputs simultaneously while balancing several conditions. That is an optimization problem and generally calls for a Solver-type tool instead.

Goal Seek also does not know the real-world limits of an input unless the tool supports constraints and you configure them. A mathematically valid answer might be a negative quantity, an impossible number of people, or a price outside your permitted range. Check whether the answer respects practical limits, units, rounding, and any assumptions elsewhere in the workbook.

Common problems and how to fix them

The result does not change: Make sure the formula cell actually depends on the changing cell. If B6 never refers to B5, changing B5 cannot affect the target.
The add-on cannot reach the target: The target may be impossible for the formula and allowed input range, or the formula may contain discontinuities or errors. Test nearby input values manually to see how the result behaves.
The answer is unreasonable: Check signs, units, and cell references. A cost entered as a positive amount may need to be subtracted; a percentage stored as 15 rather than 15% can also radically change the calculation.
The result is close but not exact: Numerical solvers can use a tolerance rather than produce an exact match. Rounding in the formula can make an exact target impossible. Inspect the reported status and the recalculated difference.
The answer changes when you run it again: Starting values and formulas with multiple possible solutions can affect which result the solver finds. Record the original values and test whether other inputs also satisfy the target.
The add-on is unavailable: Your Google account or administrator may block Marketplace tools. Try an approved alternative, ask an administrator, or use a manual calculation if the model is simple.

Goal Seek compared with Excel and Solver

Excel for Microsoft 365 on Windows includes a built-in command: Data > What-If Analysis > Goal Seek. In its dialog, set the formula cell, enter the target value, and specify the cell to change. That is the same basic task as the Sheets add-on, but Excel does not require a Marketplace extension for its standard Goal Seek feature. Excel for Mac also provides Goal Seek through the Data tools, though ribbon organization can differ by version.

Goal Seek in either spreadsheet is for one target formula and one adjustable input. Excel’s Solver add-in and optimization tools are intended for more complex models with multiple changing cells, constraints, or an objective to maximize or minimize. Google Sheets users can look for a Solver add-on for that kind of task, but should assess its publisher, permissions, and supported features just as they would for any extension.

There is no need to switch to Excel simply because you want to solve one basic target-value question: a suitable Sheets add-on or a direct calculation may be enough. Conversely, if your task needs several constraints, a native Excel feature or a carefully chosen Solver tool may be a better fit. Compare the actual requirements rather than treating all what-if tools as interchangeable.

Alternatives when you do not want an add-on

For a simple equation, solve it algebraically and enter the answer directly. In the profit example, the contribution per unit is $25 minus $10, or $15. The target quantity is the sum of target profit and fixed costs divided by contribution per unit: ($6,000 + $3,000) / $15 = 600 units. This is transparent and avoids granting an add-on access to the workbook.

For more complicated formulas, try a small table of candidate inputs and their calculated results. Change the input in steps, observe whether the formula result rises or falls, and narrow the range. This is slower than automated Goal Seek but makes the relationship visible and can help diagnose a bad formula. Keep units and rounding consistent as you compare candidates.

If you need to find the best result across several adjustable values, look for an optimization tool that supports multiple variables and constraints, rather than repeatedly applying one-variable Goal Seek. For a workbook used by others, document the target, the cell being changed, and the assumptions behind the calculation so readers can reproduce and review the result.

Frequently Asked Questions

Is Goal Seek available in Google Sheets without an add-on?
Google Sheets does not provide the same built-in Goal Seek command found in Excel. A Marketplace add-on is the typical automated option; manual algebra or a candidate-value table can work without one.

How do I use Goal Seek in Google Sheets?
Install an appropriate Goal Seek add-on, then select the formula cell, enter the target result, and identify the single input cell it may change. Check the add-on’s own instructions because its interface can vary.

Can Goal Seek change more than one cell?
Standard Goal Seek is designed to change one input cell to make one formula reach a target. Use an optimization or Solver tool if you need multiple changing cells or constraints.

Why does Goal Seek give an error or no solution?
The target may be unreachable, the formula may not depend on the selected input, or the formula may contain an error or abrupt changes. Test the formula manually and confirm the selected cells and units.

Is Google Sheets Goal Seek the same as Excel Goal Seek?
The basic idea is the same: set a formula result to a target by changing one input. Excel for Microsoft 365 includes Goal Seek under Data > What-If Analysis; Sheets generally relies on an add-on.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.