How to Use the Correlation Analysis Tool in Excel
How to Use the Covariance Analysis Tool in Excel
How to Run the Excel PivotTable Wizard

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

COMMENTS »
blog comments powered by Disqus
How to Perform Analyses of Variance in Excel
How to Rank by Percentile in Excel
How to Query an External Database in Excel
How to Set Pivot Table Options in Excel
How to Import Delimited Text Files in Excel 2013