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

Hi Matt

Try
=MAX(0,A2-B2)

--
Regards

Roger Govier


"Matt" wrote in message
...
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