ORDER SUPPLIES
 

COL 1 SUPPLY COL 2 #in stock
col1=<1 enter #2 so I can order supply or enter the word order
I don't know if I should just do a query, or what if function or what, but I
want it simple.
thanks

ORDER SUPPLIES
 

You are too vague in your request so this is jst a guess -
A B C
Supply InStock Availability
1 2 1
2 0 Out of Stock


formula for Column C

=If(B2-A21,"Out of Stock",B2-A2)






whereas ReOrder will be the qty of stock already supplied.






"NannaLuvs" wrote:

COL 1 SUPPLY COL 2 #in stock
col1=<1 enter #2 so I can order supply or enter the word order
I don't know if I should just do a query, or what if function or what, but I
want it simple.
thanks