ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   solver constraint (https://www.excelbanter.com/excel-worksheet-functions/13785-solver-constraint.html)

jojo

solver constraint
 
I used Solver to maximize the sum of a series of changable numbers. The
constraints are also given. However, the solver returns some solution that
doesn't meet the constraints. Why is that?
Another question, in solver constraint, there are =, <=, = etc. When I want
to use 0, shall I just choose = and set the value to a number that is very
close to 0, say 0.0000001?
Thanks a million!!!


All times are GMT +1. The time now is 10:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com