djhuckfield
New Member
- Joined
- Jul 18, 2014
- Messages
- 4
Hi everyone, I'm trying out Solver for the first time and it's not working as expected - hopefully someone will have some idea of what I'm doing wrong.
Below is screen print of my current layout, copied from a YouTube tutorial - I'm using Solver on cell M15, changing cells I5:I14, with constraints on cells I5:I14 and J5:J14 that they must be equal to or greater than zero. The result I'm trying to achieve in cell M15 is 56%. Every time I run it, I only get the error message that Solver cannot find a feasible solution - any ideas where I'm going wrong? I've shown the formulas I'm using in cells M5:M14 to the right of them.
Below is screen print of my current layout, copied from a YouTube tutorial - I'm using Solver on cell M15, changing cells I5:I14, with constraints on cells I5:I14 and J5:J14 that they must be equal to or greater than zero. The result I'm trying to achieve in cell M15 is 56%. Every time I run it, I only get the error message that Solver cannot find a feasible solution - any ideas where I'm going wrong? I've shown the formulas I'm using in cells M5:M14 to the right of them.
![solver_problem.jpg](/board/proxy.php?image=http%3A%2F%2Fimg.photobucket.com%2Falbums%2Fv82%2Fsatanicmantis%2Fsolver_problem.jpg&hash=abc17ab9d449dc92b7976db4a59a4e22)