Formula to order an item based on sales and quantity on hand

[Hiten Vakharia]

Hi,

I would like to create a formula where if I have sold more than 6 quantities and I have less than 3 in stock, it would ask me to create an order for 12 quantities.

Thanks in advance.

Regards,
Hiten

 

[kweaver]

Do you mean something like this?

Excel 2010
	A	B	C
1	QTY On-Hand	Sold	ORDER
2	10	10
3	20	25
4	2	8	ORDER 12
5	1	20	ORDER 12
Sheet2

Cell Formulas
Range	Formula
C2	=IF(AND(B2>6,A2<3),"ORDER 12","")