Hello,
I'm working on a simple linear programming problem where I have to minimise costs.
One of the constraints is that in a food mix, the ratio of ingredient A to ingredient B cannot exceed 3 to 1.
What I did is create a new cell and typed in: =(3*(E20))/D20 where E20 and D20 are cells with amounts of ingredient A and B respectively.
The problem is that I get the #DIV/0! (division by zero) error, since solver will also try some solutions where D20 is zero.
How to re-write this
Thanks
Bookmarks