Microsoft KB Archive/214263

= XL: Example on Use of Solver =

Article ID: 214263

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q214263



For a Microsoft Excel 97 and earlier or Microsoft Excel 98 Macintosh Edition and earlier version of this article, see 142130.



SUMMARY
The Solver add-in that ships with Microsoft Excel is used to find solutions to "what-if" scenarios based on adjustable cells and constraint cells. This article gives an example of how to set up a model on a worksheet and how to use Solver to find a solution to the model based on the constraints in the model.



MORE INFORMATION
Follow these steps to create the model on a worksheet:

 Open a new worksheet.  Type the following on the worksheet:

     A1: 1 A2: -3 A3: A4: =A1*A3^2+A2*A3+2  On the Tools menu, click Solver.

NOTE: If Solver is not on the Tools menu, you need to make sure the Solver add-in is listed and selected in the Add-ins dialog box. In the Solver Parameters dialog box, in the Set Target Cell box, enter A4. Click Value Of and set the value to 0. In the By Changing Cells box, enter A3.</li> Under Subject to the Constraints, click Add.</li> Type A3 in the Cell Reference box, click ">=" in the list, and in the Constraint box, type 1.5. Click OK.</li> Click Solve.</li></ol>

You should get the Solver Results dialog box stating that Solver found a solution and the value in cell A4 should now be 0, or very close to zero (1.04E-07, for example). Click OK to return to the worksheet.

<div class="references_section">