Excel Solver not obeying binary constraint

excel solver
Shaggy Frog picture Shaggy Frog · Aug 25, 2009 · Viewed 44.8k times · Source

I created a model in Excel to use in conjunction with Solver. It mostly works. The only problem is that Solver is not really treating the cells constrained as binary properly. When it's done finding a solution, some of the numbers are actually 0.9999996, 1.0000000003, 0.0000017, and so on.

I am using Excel 2004 on Mac OS X. Any ideas?

Answer

thomas picture thomas · Feb 1, 2011

If the binary values are far from 0 or 1, you might have to go to options in the Solver window and check if the box "Ignore integer constraints is checked".

Related questions

Is there an Excel Function to find a combination of numbers

I am not familiar with all of excel's functions and data tools, though I am familiar with excel. My problem is that I have a number on a spreadsheet which is a combination of many different numbers on a list. …

Read More
Excel Solver Password: what is it and where can it be acquired/bought?

I've been exploring VBA and excel and I've been writing a few basic codes around the Excel Solver. However robust the Excel Solver may appear, it's just not fast enough for my optimization problem (one iteration takes 20 minutes). I've been …

Read More
Does anyone know a better alternative to MS Excel's Solver?

My company has to crunch a lot of data and part of the process involves running the solver and plotting a graph through resulting data points. Obviously there is a lot of copy and paste involved and the whole process …

Read More