IF statement and subtractiom

[vanilz]

Hi Excel Gurus,

I have 2 tables, Stock availability and Sold item. Not sure if this is possible using excel if else and formula to subtract the availability stock.

If D3 or D4 filled with text available in A3:A4, then it take the quantity on E3 to subtract B3 and E4 subtract B4.

Thank you in advanced.

 

[julhs]

Try this

Book1
	A	B	C	D	E	F	G
1	Stock availability			Sold item
2	Item Description	Quantity		Item Description	Quantity	Stock talley
3	Apple	20		Apple	5	15
4	Banana	16		Banana	8	8
5
Sheet1

Cell Formulas
Range	Formula
F3:F4	F3	=IF(E3>B3,"Over sold item",IF(A3=D3,B3-E3,"No items listed"))

 

[Sufiyan97]

Try

Book2
	A	B	C	D	E	F
1	Stock availability			Sold item
2	Item Description	Quantity		Item Description	Quantity	Day End Stock
3	Apple	20		Apple	5	15
4	Banana	16		Banana	8	8
Sheet1

Cell Formulas
Range	Formula
F3:F4	F3	=SUMIF($A$3:$A$500,A3,$B$3:$B$500)-SUMIF($D$3:$D$500,D3,$E$3:$E$500)

 

[julhs]

Tweek to mine.

=IF(AND(A3="",D3=""),"",IF(E3>B3,"Over sold item",IF(A3=D3,B3-E3,"No items listed")))