Hello I have a spreadsheet
From cells A5 to A10 i have item names
Cell B5 to B10 i have the items stock e.g 100, 50
In Cells C5 to C10 i would like to make a IF statement
=IF(B12>30,"Stock Valid","Stock replacing"
how do i edit this so that not only does it show
when stock level is above 30 its should say Stock Valid - This works
When stock level is below 30 it shows Stock replacing -- This Works
How do i make it say when stock level is 0 - it should say Order
Thank You
Bookmarks