View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default I Need a Formula to return a zero value

What formula do I need to return a zero value in the re-order column when the
value is =0 or <0 i.e. a Negative value. This will eliminate the holding
stock and enable new items to be added.
Par Level On Hand Re Order
5 4 1
6 5 1
0 1 0
8 6 0
9 7 0
10 9 0