Example on Use of Solver

MORE INFORMATION

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 the Value Of option and set the value to 0.
6. In the "By Changing Cells" box, enter A3.
7. In the "Subject to the Constraints" area, 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.