In Excel 2010, 2011, and 2013, make sure the solving method is set to Simplex LP. Simplex LP is appropriate for this problem, because this problem is linear (the “L” in LP stands for linear).

What Does Excel's Solver Do? In short, Solver is like Goal Seek on steroids. If you were wondering how to use Goal Seek in Excel for multiple cells at once, this is it.

In this guide, I'll show you how you can use it to solve real-world problems. To follow along as you read this guide, download a free copy of the Excel workbook used in the examples .

Excel can solve equations through several of its mathematical functions, but the single Excel tool that works on the largest variety of equations is the program's Solver Add-in. This tool reads an ...