I'm trying to add a constraint to my excel file, but every time I add the binary constraint, I get this error ""binary constraint cell reference must include only variable cells"
It looks like it's almost undocumented.
Edit:
I figured it out. In order for binary constraint to work, you have to use cell reference of cells used in the Set Objective cell. If you try to set the binary constraint to cells not mentioned in the Set Objective cell, then this error will always occur.
I tried but it is still not working. The set objective is B31, which is using G14:H18, but when I try to set G14:H18 as Binary, I get the same error.
Please refer to the attached file and help.
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks