Hi All,
I should probably know this but I have got a mental block
I have a quantity of stock in Cell A
If that goes to -1 or less then I want to say "Supply Exceeded"
If that is between -1 & +1 I want to say "Supply Consumed"
If that is >1 I want to say "Supply Available"
Anyone able to help me with that please?
Thanks
I should probably know this but I have got a mental block
I have a quantity of stock in Cell A
If that goes to -1 or less then I want to say "Supply Exceeded"
If that is between -1 & +1 I want to say "Supply Consumed"
If that is >1 I want to say "Supply Available"
Anyone able to help me with that please?
Thanks