Solver binary but when getting the result is decimal, is it bug?

Question

im using solver tools, after that solver parameter panel appear, i do that code or array in subject to the constraint "$E$10:$E$13 = binary" but the result after i press solve is 0,4 in array E10. so is it bug or something i dont know (very newbie to this). thank you for anyone want to help

Answer 1

Hi,

This is not a bug. It usually happens when the Solver is not strictly enforcing the binary constraint due to the solving method or model setup. Even though you set the cells as binary, getting a value like 0.4 means Solver is treating the problem as a relaxed (continuous) model.

Make sure you are using the Simplex LP method with all constraints correctly defined, and double-check that the “Make Unconstrained Variables Non-Negative” option is enabled. Also, try re-adding the binary constraint or switching to the Evolutionary method to enforce integer/binary results more strictly.

In short, it’s a configuration issue, not a bug.