Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1
In D1 use this =If(C1<=0,0,C1) or make C1 this formula
=If(A1-B1<=0,0,A1-B1)
--
intruder9
------------------------------------------------------------------------
intruder9's Profile:
http://www.excelforum.com/member.php...o&userid=30107
View this thread:
http://www.excelforum.com/showthread...hreadid=524547