How to Have Excel Solver Give Only Whole Numbers

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Image Credit: Siri Stafford/Digital Vision/Getty Images

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.


Step 1

Go to the "Data" tab in Excel, and click the "Solver" button to launch the Solver dialogue box.

Video of the Day

Step 2

Click the "Add" button under Constraints to launch the "Add Constraints" dialogue box.


Step 3

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.


Step 4

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.

Step 5

Click "OK"




Report an Issue

screenshot of the current page

Screenshot loading...