Thank you so much. =If(A1-B1<=0,0,A1-B1) did exactly what i needed it to do.
"intruder9" wrote:
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