inventory spreadsheet

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

Hi All
Wanted to know how to get a "YES" put into a formula
Example....
I have a minimum number of an item
I have an in stock number of that item
I have a need number of that item
I have an order column (yes or no)
I subtract the minimum number from the in stock number to get the number
needed
If the number needed equals a negative number I need the order coloumn to
say no
If the number needed equals a positive number I need the order coloumn to
say yes

I hope that makes sense

roy
tia
 
Back
Top