inventory spreadsheet

[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

 

[EZ Money]

=IF(A1<=0,"No","Yes")

 

[Roy]

Thanks for the quick response that worked perfectly