Use Solver : Solver « Data Analysis « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Data Analysis
  3. Solver
Click the Data tab. Then click the Solver button.
Click the Data tab. Then click the Solver button.
Select the target cell.
Select the target cell.
Click an Equal To option, and then, if necessary, enter a value.
Click an Equal To option, and then, if necessary, enter a value.
Select the cell range the solver uses to compare against the target cell.
Select the cell range the solver uses to compare against the target cell.
Click Add.
Click Add.
Enter specific cell reference and constraint, and then click Add.
           Click OK.
Enter specific cell reference and constraint, and then click Add.
Click Solve.
Click Solve.
If the Solver finds a solution, the Solver Results dialog box opens.
           Click the Keep Solver Solution option.
           Click a report type.
           Then click OK.








10.4.Solver
10.4.1.Add/Install Solver Add-inAdd/Install Solver Add-in
10.4.2.Use SolverUse Solver