Solve Systems of Equations in Excel - From Developers of the Microsoft Excel Solver

You are here

If you want to find numerical solutions for single equations or systems of equations -- or inequalities -- and Microsoft Excel is a familiar or productive tool for you, you've come to the right place! You can use Solver, a built-in component of Excel -- that Frontline Systems originally developed for Microsoft.

What if you need to solve systems of more than 200 equations or inequalities -- the limit of the build-in Solver? You can easily upgrade to Premium Solver -- it's 100% upward compatible from the Excel Solver. Your Solver models, and even VBA code controlling the Solver, will work as-is. Premium Solver handles up to 400 nonlinear equations, and up to 1,000 linear equations.

With Premium Solver Platform -- a further upgrade from Premium Solver -- you can handle up to 500 nonlinear equations, and up to 8,000 linear equations! And Premium Solver Platform includes our Interval Global Solver, which can do more with nonlinear systems: Given sufficient time, it can isolate all real solutions of a system of smooth nonlinear equations -- that's beyond the capabilities of most other software!

The Premium Solver products do more than solve equations -- they also find optimal solutions to problems with decision variables, constraints that may be equations or inequalities, and an objective to be maximized or minimized. And they handle the full spectrum of optimization problems, from linear programming and smooth nonlinear optimization to non-smooth models using arbitrary Excel functions, solved via genetic algorithm methods.

P. S.: You don't have to be an expert in equation-solving or other mathematical methods. For more than a decade, thousands of users in Global 2000 companies have taken advantage of our advanced software and knowledgeable tech support to build and solve bigger and better models.

Our best-selling product for conventional equation-solving and optimization is Premium Solver Platform, in part because it can handle every type of problem up to certain size limits:

Linear and quadratic problems up to 8,000 variables

Conic and mixed-integer problems up to 2,000 variables

Smooth nonlinear, global, and nonsmooth problems up to 500 variables

And you'll want Premium Solver Platform even if your problem is larger than these limits, because it is the base or "platform" that all of our larger-scale Solver Engines "plug into." If your problem grows in size, you can easily add one or more Solver Engines to the Premium Solver Platform at any time. Think your model is too big? Don't worry -- some of our users have linear programming models with millions of decision variables!

What's more, you can upgrade Premium Solver Platform to our "super-product" Risk Solver Platform, at any time, for the difference in price -- gaining powerful Monte Carlo simulation and simulation optimization capabilities, plus new stochastic programming and robust optimization capabilities -- not available anywhere else -- to help you find robust optimal decisions for problems with uncertainty.

If the Premium Solver Platform is too much for your budget, and if you just need to solve a modest-size linear, mixed-integer, or smooth nonlinear model, you can use our Premium Solver for less.

Premium Solver is not "expandable" to solve large-scale optimization problems. All of our "plug-in" large-scale Solver Engines require Premium Solver Platform or Risk Solver Platform, and the Polymorphic Spreadsheet Interpreter, available only in these Platform products, plays a crucial role in the efficient solution of large-scale problems.

Just enter your name and email address, and optionally your company and phone, pick the closest "User Type," and click the Register for Download button. You can download immediately after registering, or return later anytime -- just login with your email address -- when you're ready to try out our Excel Solver upgrades.