Thread: number < 0 = 0
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
intruder9
 
Posts: n/a
Default number < 0 = 0

Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1
In D11 use this =If(C1<=0,0,C1)


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=524547

Reply With QuoteReply With Quote