Math Behind Excel Solver Complete Guide

Now we demonstrate how to use Excel spreadsheet modeling and Solver to find the optimal solution of optimization problems. To ensure that I understood the physics behind the table I decided to use Excel and Solver to generate it on my own. Major spreadsheet packages come with a built-in optimization tool called Solver.

Here is where Solver shines it supports integer programming.

You can use Solver in both. Once you click on Solver it will open the below dialogue box. Very few real world problems involve only two variables. Get help on the web or with our math app.