If we had non-linear calculations in the model (perhaps a square root of a decision, a logarithm, or an exponential function), then we could use one of the other algorithms Excel provides in Solver.

“Modeling and solving nonlinear optimization problems has always been a fascinating field of research for me,” said Andrea Lodi, an Andrew H. and Ann R. Tisch Professor at the Jacobs Technion ...

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.

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