Forum Discussion

Vrenzcha's avatar
Vrenzcha
Copper Contributor
Apr 03, 2023

I can't do binary option in solver

Dear Microsoft,

I am taking a class about analytics which depends on excel. I am learning about Mixed Integer Linear Programming where the binary constraint is needed. This message shown below keeps popping up everytime I click the binary option when my teacher and classmates do not have any issue with this. My integer option works but not binary, what should I do?

excel

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Apr 03, 2023

    Vrenzcha 

    Based on web search results, one possible solution to your problem could be

    to go to Solver -> Options -> Uncheck "Ignore Integer Constraints".

    This has helped other users fix a similar issue. 

     

    Hope I was able to help you with this info.

Resources