Excel 2019 Bible

(singke) #1

Part IV: Managing and Analyzing Data


FIGURE 32.9
You can control many aspects of the way Solver solves a problem.

Max Feasible Solutions Use this for complex problems. Specify the maximum number of
feasible solutions that may be explored by the Evolutionary algorithm.

The other two tabs in the Options dialog box contain additional options used by the GRG Nonlinear and Evolutionary
algorithms.

Seeing Some Solver Examples


The remainder of this chapter consists of examples of using Solver for various types of
problems.
Free download pdf