ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why is excel solver saying that there is not a feasible solution? (https://www.excelbanter.com/excel-programming/350660-why-excel-solver-saying-there-not-feasible-solution.html)

jt13

Why is excel solver saying that there is not a feasible solution?
 
When the optimisation solution that I am trying to solve has easy parameters
to fit, solver replies that there is not a feasible slution although a
solution has provided that appears to be feasible

Bill Martin[_2_]

Why is excel solver saying that there is not a feasible solution?
 
jt13 wrote:
When the optimisation solution that I am trying to solve has easy parameters
to fit, solver replies that there is not a feasible slution although a
solution has provided that appears to be feasible


Since you have not provided any specifics, we can't discuss your specific problem.

However in general I find that Solver works well for "simple" continuous
problems. Finding the parameters for the equation of a line of some kind for
example.

It seems to work poorly for me however when the problem is highly non-linear or
discontinuous - perhaps when there are If/Then statements involved in the
evaluation for example.

Bill


All times are GMT +1. The time now is 02:25 AM.

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