Excel 2010 solver not working properly -
i'm trying set system of equations reference cells. i'm trying left side of each equation equal right side, changing variable cells.
to cut chase, solver returning there no solution. there solution established set of equations.
on looking it, removed constraints until found problem; excel solver not attempting use negative numbers inputs solve equation. simplified 1 constraint solved making 1 input -1 , leaving else same, , still returned no results, every other constraint met fine.
i'm not sure if there reason why excel not trying use negative numbers. did not include objective in solver function because not necessary, still worked other constraints.
i'm using excel 2010. thanks
check setting "make unconstrained variables non-negative":
if turned on variables restricted positive.
Comments
Post a Comment