How to Rank by Percentile in Excel
How to Enter a Function in Excel with the Function Command
How to Run the PivotTable Wizard in Excel

Set Up and Define Problems in Excel's Solver Add-In Utility

Click the target cell in the worksheet or enter its cell reference or range name in the Set Objective text box.

Next, you need to select the To setting. Click the Max option button when you want the target cell’s value to be as large as possible. Click the Min option button when you want the target cell’s value to be as small as possible. Click the Value Of option button and then enter a value in the associated text box when you want the target cell’s value to reach a particular value.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Use the Correlation Analysis Tool in Excel
How to Run the Excel PivotTable Wizard
How to Use Data Validation to Keep Excel Data Clean
How to Perform Analyses of Variance in Excel
How to Use AutoFilter on an Excel Table