ORDER SUPPLIES

N

NannaLuvs

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
 
E

exceluserforeman

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-A2>1,"Out of Stock",B2-A2)






whereas ReOrder will be the qty of stock already supplied.
 
Top