SolveFill: Goal Seek & Linear Solver

SolveFill is an add-on for Google Sheets™ with Goal Seek and a solver for linear and integer models, using the fields of the Goal Seek and Solver dialogs in Microsoft Excel: Set Objective; Max, Min or Value Of; By Changing Variable Cells; Subject to the Constraints.

Goal Seek: make a formula cell show the value you want by changing one input cell, usually in a handful of recalculations. Free, as often as you like.
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. Models are solved by Google’s LinearOptimizationService inside Apps Script, so your spreadsheet’s contents never leave Google.
Every answer checked: SolveFill writes the answer, recalculates your sheet and checks every constraint and the objective before showing it. A model that is not linear is named by its cell and left as it was.
Your values come back if you want them: keep the solution or restore your original values. An optional Answer Report on a new sheet shows each constraint’s status and slack.

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

Plans

Free: Goal Seek, unlimited, and 3 solves in total per Google account. A solve that finds no answer, and creating the sample model, use none.
SolveFill: $9 once per Google account for unlimited solves. No subscription. Refunds within 14 days. See the terms.

Install it from the Google Workspace™ Marketplace, then open it from Extensions > SolveFill in any spreadsheet.

Add-on will not open or uses the wrong Google account?

Microsoft and Excel are trademarks of Microsoft Corporation. SolveFill is not affiliated with, sponsored or endorsed by Microsoft.