IF statement

[mickyd67]

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

 

[Joe4]

Try a nested IF, i.e.

=IF(A1<=-1,"Supply Exceeded",IF(A1>1,"Supply Available","Supply Consumed"))

Note it is unclear what should happen if it exactly equals 1.
Currently, it will return "Supply Consumed".
If you want "Supply Available", changed "A1>1" to "A1>=1".

 

[mickyd67]

Try a nested IF, i.e.

=IF(A1<=-1,"Supply Exceeded",IF(A1>1,"Supply Available","Supply Consumed"))

Note it is unclear what should happen if it exactly equals 1.
Currently, it will return "Supply Consumed".
If you want "Supply Available", changed "A1>1" to "A1>=1".

Great. Thanks, Joe!

I'll adjust the formula for exactly 1 now that I know how to do the rest of it

 

[Joe4]

You are welcome.
Glad I was able to help!