Share via

Excel solver: Constraints not working

Anonymous
2020-09-05T06:01:33+00:00

The objective is to minimize the Sumproduct of the two tables.

The cells X3:X5 equal to 0 if the corresponding cell in K3:K5 equals zero. However, the solver always gives a solution where K3:K5 are zeros and V3:V5 has values.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2020-09-05T08:17:37+00:00

    We need to see your file.

    Login to https://onedrive.live.com/ (Use the same Login ID and password as for this forum).

    Click Upload in the top and choose your file.

    After uploading, right click the file and choose share.

    Click Get a Link.

    Copy the link and paste it here.

    Andreas.

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2020-09-05T12:36:49+00:00

    Thank you for your detailed instructions! Here's the link for the file:

    https://1drv.ms/x/s!AmsQnoiduX-9iS\_cm08VO27qa0P1?e=7WdiWJ

    0 comments
  4. Anonymous
    2020-09-05T12:42:00+00:00

    Thank you for your reply!!

    I have actually tried putting only those cells I want to change in the changing variables before, but didn't work as well. This is only one version of my setting... 

    On the other hand, when the solver is working with the current setting, I can still see K6:O9 and P3:U5 being put values in, which means that these constraints may not be working properly as well.

    0 comments
  5. Andreas Killer 144K Reputation points Volunteer Moderator
    2020-09-05T13:59:47+00:00

    On the other hand, when the solver is working with the current setting, I can still see K6:O9 and P3:U5 being put values in, which means that these constraints may not be working properly as well. 

    I've checked the Solver settings and the values in the file, all constraints were met.

    K6:O9 and P3:U5: Your constraints requires this cells to be 0 and they are 0. Look at your own screenshot.

    From the mathematical view, the solution may not meet your expectations, but is correct.

    Andreas.

    0 comments