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

With this example, type "A1." Click "Solve." Excel will replace cell A1 with the equation's solution. With this example, it will insert the value "21," the equation's solution, into cell A1.

If you want to use Excel's Goal Seek on multiple cells simultaneously, you'll need a much more powerful tool. Fortunately, one such tool comes with Excel. Let's have a look at the Solver add-in.