Share via

Whenever I use solver, the changing variable cells become 0.

Anonymous
2024-10-20T20:57:35+00:00

I have already tried deleting and redownloading Excel. I checked that my Mac en.lproj/Add-ins said Solver.xlam. Another suggestion was to rename it Solver 2.xlam, but it still doesn't work.

Microsoft 365 and Office | Excel | For education | MacOS

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

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-20T21:19:20+00:00

    In a Supply / Demand model, it looks to me that your model is not set up correctly.

    The most obvious problem is that your objective :

    =Sumproduct ( row 13, Row 14)

    Your Row 14 are all blank! So, the objective will always be zero.

    0 comments
  2. Anonymous
    2024-10-20T21:30:39+00:00

    I added in the values and my results are still blank.

    0 comments
  3. Anonymous
    2024-10-21T00:25:11+00:00

    The minimum solution of your SumProduct is Zero, so it appears to me to be correct.

    If you need help with your model, post your workbook, and what you are trying to do.

    0 comments
  4. Anonymous
    2024-10-21T20:33:38+00:00
    1 person found this answer helpful.
    0 comments
  5. 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