How to Solve Linear Programming in Spreadsheet. Solving linear programming problems in a spreadsheet yields equations for maximizing business profits.

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).