Add/Install Solver Add-in : Solver « Data Analysis « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Data Analysis
  3. Solver
Click office button. Then click the Excel Option.
Click the Data tab. Then click the Solver button.
Click the Add-in and click the solver in the list.
Select the target cell.
Click GO
Click an Equal To option, and then, if necessary, enter a value.
Select Solver add-in in the list. Click OK.
Select the cell range the solver uses to compare against the target cell.
Click OK to install Solver. Solver button is added to Data tab.
Then click OK.








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