How to Do Goal Seek in Google Sheets

Updated August 2026 · 8 min read · Goal Seek – Fast & Private

Goal Seek answers the backwards question: you know the result you want a formula to produce — what input gets you there? What price makes profit exactly zero? What monthly return turns your savings plan into 40,000 €? What score do you need on the final exam?

The example we'll use: a break-even price

Say you sell a product and want to know the price at which you stop losing money:

At a price of 49.00 the profit formula shows −1,800. The goal: set B5 to 0 by changing B2. (The answer is 53.50 — let's get Sheets to find it.)

Way 1: Solve it manually

For formulas you can rearrange, you don't need any tool. Break-even price is simple algebra:

=B3 + B4/B1 → 31 + 9000/400 = 53.50

The manual route breaks down when the formula chain is too tangled to invert — nested taxes and discounts, compound interest, IF-logic, anything built from several sheets. Then you either try values by hand (tedious) or let a solver iterate for you.

Way 2: Google's official Goal Seek add-on

1. Extensions → Add-ons → Get add-ons, search for “Goal Seek”, install Google's own add-on.
2. Extensions → Goal Seek → Open, then choose the target cell, target value and the cell to change.
3. Click Solve.

It's free and made by Google — for a formula like our break-even example it will get there. Be aware of its trade-offs, though: it was last updated in 2023, it requests access to all your spreadsheets, and its reviews regularly report runs of 20+ seconds and convergence errors on stepped formulas such as SUMIFS. If it works for you, keep it — if it feels slow or fails on your model, the next option was built exactly for those cases.

Way 3: Goal Seek – Fast & Private

Goal Seek – Fast & Private is our take on the same idea, designed around the three complaints above:

• Fast: a bracketing solver that typically needs only a handful of recalculations — most seeks finish in a few seconds.
• Private: it can only access the spreadsheet you run it in (spreadsheets.currentonly scope) — not your Drive, not your other files. No external servers.
• Honest: if there is no solution it says so, shows what it tested and the closest value it found. Stepped formulas (SUMIFS, FLOOR, lookup buckets) are detected and reported with the best achievable value instead of a cryptic error.

Using it on the example:

1. Install Goal Seek – Fast & Private from the Google Workspace Marketplace (free, takes under a minute).
2. Open Extensions → Goal Seek → Open Goal Seek.
3. Set cell: B5 — To value: 0 — By changing cell: B2 (the sidebar prefills from your selection).
4. Press Seek goal. You'll see live progress and an iteration log; the result card shows old → new value, deviation and time.
5. Keep the solution — or restore the original value with one click. The original cell content is backed up before the first write, so a failed or cancelled run never damages your sheet.

A second example: what return does your savings plan need?

Some questions have no algebraic shortcut. Suppose you save 250 € per month for 10 years and want to end up with 40,000 €:

Goal Seek: set B4 to 40,000 by changing B3. The solver lands at roughly 0.46% per month (about 5.7% per year) — a number you can't cleanly isolate with algebra, found in a few seconds of iteration.

Troubleshooting: when Goal Seek "doesn't work"

• “No sign change found” — across everything the solver tested, your formula never crossed the target value. Often the goal is simply unreachable (a squared term can't go negative), or the search needs a hint: set a different start value or bounds.
• The formula moves in steps — SUMIFS over brackets, FLOOR/CEILING, tiered lookup tables. No input hits the target exactly; a good solver offers the closest achievable value and says why.
• The target cell shows an error (#DIV/0!, #N/A) for some inputs — the solver has to navigate around those regions; if the error appears for every input, fix the formula first.
• Nothing changes — check that the target formula really depends on the cell you're varying (trace the chain; a hard-coded number somewhere in between is the usual culprit).
• The target cell contains a value, not a formula — Goal Seek needs a formula to recalculate. Point it at the formula cell.

FAQ

Does Google Sheets have a built-in Goal Seek?

No. Excel ships Goal Seek under Data → What-If Analysis; Google Sheets requires an add-on (or manual solving).

Is Goal Seek in Google Sheets free?

Yes — Google's add-on is free, and Goal Seek – Fast & Private includes a free plan (5 runs per day, resets at midnight Central European Time).

Can Goal Seek change several cells at once?

No. Goal Seek varies exactly one input. For multiple inputs plus constraints you want an optimizer (e.g. a linear-programming solver), which is a different class of tool.

Is my data safe with a Goal Seek add-on?

Check the permissions at install time. Google's own add-on asks for access to all your spreadsheets; Goal Seek – Fast & Private deliberately uses the restricted spreadsheets.currentonly permission, which covers only the file you run it in, and sends nothing to external servers — see the privacy policy.

← Goal Seek – Fast & Private for Google Sheets