Using solver in Microsof Excel XP?

Question

i am doing a project in math and i have to use the microsoft xp program and i have to use solver

how do you use it
help please

Answer 1

Define and solve a problem by using Solver
On the Tools menu, click Solver.
If the Solver command is not on the Tools menu, you need to install the Solver add-in.

How?

In the Set Target Cell box, enter a cell reference or name for the target cell. The target cell must contain a formula.


To have the value of the target cell be as large as possible, click Max.
To have the value of the target cell be as small as possible, click Min.

To have the target cell be a certain value, click Value of, and then type the value in the box.

In the By Changing Cells box, enter a name or reference for each adjustable cell, separating nonadjacent references with commas. The adjustable cells must be related directly or indirectly to the target cell. You can specify up to 200 adjustable cells.
To have Solver automatically propose the adjustable cells based on the target cell, click Guess.

In the Subject to the Constraints box, enter any constraints you want to apply.


Click Solve.


To keep the solution values on the worksheet, click Keep Solver Solution in the Solver Results dialog box.
To restore the original data, click Restore Original Values.

Tips

You can interrupt the solution process by pressing ESC. Microsoft Excel recalculates the worksheet with the last values found for the adjustable cells.