Division by zero - Solver

[NeoXx]

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

[FoxSeaLady]

Hi

Try iferror((3*(E20))/D2,0)

Cheers

[Alf]

Or perhaps add a constraint for D20 i.e.

Please Login or Register  to view this content.

Alf