Excel Solver is an optimization algorithm produced by Frontline Systems, Inc. that is designed to analyze models of engineering and finance in a spreadsheet. Solver can be described as a function that answers "what if" questions in business. For example, if a company has a certain budget, Solver can determine how to best allocate that budget to meet the company's given product needs. Naturally, most products cannot be purchased in fractional amounts, so Solver can be configured to report totals in only whole numbers.
Go to the "Data" tab in Excel, and click the "Solver" button to launch the Solver dialogue box.
Video of the Day
Click the "Add" button under Constraints to launch the "Add Constraints" dialogue box.
Enter the name of the cell in the "Cell Reference" box, or highlight a range of cells with your cursor to fill this box automatically.
Click the drop-down menu in the middle of the "Add Constraints" dialogue box, and select "int" from the menu. The word "integer" will appear in the Constraint box.