XL2000: Example on Use of Solver

ID: Q214263

The information in this article applies to:
  • Microsoft Excel 2000

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:

  1. Open a new worksheet.


  2. Type the following on the worksheet:
    
      A1: 1
      A2: -3
      A3:
      A4: =A1*A3^2+A2*A3+2


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


  4. In the Solver Parameters dialog box, in the Set Target Cell box, enter A4.


  5. Click Value Of and set the value to 0.


  6. In the By Changing Cells box, enter A3.


  7. Under Subject to the Constraints, click Add.


  8. Type A3 in the Cell Reference box, click ">=" in the list, and in the Constraint box, type 1.5. Click OK.


  9. Click Solve.


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.


REFERENCES

For more information about Solver, click Microsoft Excel Help on the Help menu, type "solver" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words: XL2000

Keywords : kbtool xlwiz
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto


Last Reviewed: May 13, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.