Excel-style What-If Analysis for Google Sheets™: Goal Seek, data tables, scenarios and an optimization solver, with the fields of the Goal Seek, Data Table, Scenario Manager and Solver dialogs in Microsoft Excel.

GOAL SEEK, FREE
Make a formula cell show the value you want by changing one input cell, such as the interest rate that brings a loan payment to 350. Usually a handful of recalculations. Free, as often as you like.

DATA TABLES
See what a formula gives for a list of inputs, such as the loan payment at each interest rate, or at each rate and amount. Lay the table out as in Excel, with a Row input cell, a Column input cell or both; SolveFill tries each value in your sheet and writes the results into the table. Up to 1,000 values per table.

SCENARIOS, FREE
Save named sets of values for your changing cells (best case, worst case, base), show any of them in the sheet and restore after, and make a Scenario Summary on a new sheet: each changing cell and result cell, now and under each scenario.

LINEAR AND INTEGER SOLVER
Maximize, minimize or reach a value with up to 1,000 variable cells, constraints with <=, = and >=, and whole-number (int) or yes/no (bin) variables: product mix, staffing, shipping, budgets, blending. Models are solved by Google's own LinearOptimizationService inside Apps Script™, so the contents of your spreadsheet never leave Google.

EVERY ANSWER CHECKED
SolveFill writes the answer, recalculates your sheet and checks every constraint and the objective before it shows you anything. A data table whose formulas would read its own results is left as it was. A model that is not linear is named by its cell and left as it was. Keep the solution or restore your original values, and add an Answer Report on a new sheet with each constraint's status and slack.

3 FREE RUNS, THEN $9 ONCE
Three runs free in total per Google account, each a solve, a data table or a Scenario Summary; a run that finds no answer does not count. Then $9 once for unlimited runs, with no subscription. Refunds within 14 days. Goal Seek and scenarios stay free.

Not in this version: nonlinear models, the Sensitivity and Limits reports.

Microsoft and Excel are trademarks of Microsoft Corporation. SolveFill is not affiliated with, sponsored or endorsed by Microsoft. Google Sheets™ and Apps Script™ are trademarks of Google LLC. SolveFill is independently developed by Spyridon Pikoulas and is not affiliated with Google.