Excel solver binary constraint help
June 19, 2008 11:53 AM Subscribe
Why is Excel Solver not using the binary constraints I've set?
posted by mtstover to computers & internet (12 answers total)
I've created a table which calculates an answer based on a set of binary flags (0,1) --- basically a sumproduct type function. I'm trying to minimize the answer. But when I run solver (setting a binary constraint on those cells), it doesn't actually use binary numbers and instead is using a whole bunch of fractions.