G
Guest
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
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