Excel Solver example and step-by-step explanation | Solver | Excel

Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell

Excel’s Solver tool is an optimization package. It finds the optimal solution to a problem by changing multiple variables.
It can solve for more complex “what-if-analysis” which Goal Seek can’t. Goal seek is restricted to changing one variable, whereas with a solver you can have many variables.

Calling Solver an “advanced goal seek” doesn’t do it any justice. The solver can handle complex data models and solve for the optimal solution. But; it can also easily solve the simpler problems that we might face at work.

свернуть