Hi all,
I am trying to come up with a formula in excel. Here it is:

G H I J K
Inventory Orders Safety Production Calculation
45 25 10 -10
(Orders+Safety)-Inventory

What I am trying to do is that whenever the production cell is
negative, It has to be always 0. However, In order to make it 0, the
safety cell should be Safety= Inventory-Orders. So, Safety should be
20 in order for Production to be 0. In the calculation column, I put
=IF(J3<0,I3=E3-G3,0), but that does not work. What formula would you
suggest? I would appreciate your help.