Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Perform Analyses of Variance in Excel
How to Import Delimited Text Files in Excel 2013
How to Import a Database Table 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 Custom AutoFilter on an Excel Table
How to Enter a Function in Excel with the Function Command
How to Run the PivotTable Wizard in Excel
How to Rank by Percentile in Excel
How to Import Straight Text in Excel 2013
Advertisement

Inside Dummies.com