Check the "Solver" check box in the new window that appears, then close all dialog boxes. Excel adds the command Solver to its Data tab. Click "Solver," then click your objective formula's cell.

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.

As the title suggests, I have a problem in which I need to formulate an LP model. I'm supposed to work in Excel and use the Solver Add-in feature.I've done several other problems already, but this ...