Formula with IF & And if Blank then 0

[Yogesh977]

Dear Expert,

Please help me with below formula in not able to capture formula if cell one cell or both cell is blank. for reference Image with formula attached and sheet as below

i need you help please help me if its possible for you all experts.
Thank for your support.

	A	B	C	D	E	F	G	H	I	J	K
1​	Status	Sr.No.	My Tax Number	Vendor Tax Number	Product Amt	Tax %	Central Tax @9%	State Tax @9%	Integrated Tax @18%	Total Invoice Amt	Remark
2​	Correct	1st Formula	27	27	1000	18%	90	90	0	180	if My tax and Vendor tax are same then Central and State tax calculation and Integrated tax 0 (this formula is correct)
3​	Correct	2nd Formula	27	26	1000	18%	0	0	180	180	if My tax and Vendor tax are Different then Central and State tax is "0" and Integrated tax calculated on Tax rate (this formula is correct)
4​	Not able to do	3rd Formula	27		1000	18%	0	0	180	180	if My tax Number is Applicable and Vendor tax is Blank then Central, State tax and Integrated tax Should be "0", (this I'm not able to find how to do)

 

[Yogesh977]

Sorry My fault:

=IF(OR(D2="",C2=""),0,IF(LEFT(C2,2)<>LEFT(D2,2),E2*F2,0)

Thanks you So much Maabadi all formula is correct its help me lot....i appreciate your Excel expertise Thank you so Much once again..

GST Formula.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Status	Sr.No.	My Tax Number	Vendor Tax Number	Product Amt	Tax %	Central Tax @9%	State Tax @9%	Integrated Tax @18%	Total Invoice Amt	Thanks Giving
2	Correct	1st Formula	18AABCU9603R1ZM	18AABCU9603R1Z2	1000	18%	90	90	0	1180	Credit to @maabadi
3	Correct	2nd Formula	18AABCU9603R1Z2	04AABCU9603R1ZV	1000	18%	0	0	180	1180	Credit to @maabadi
4	Correct	3rd Formula	18AABCU9603R1Z2		1000	18%	0	0	0	1000	Credit to @maabadi
5	Correct	4th Formula			1000	18%	0	0	0	1000	Credit to @maabadi
Sheet2

Cell Formulas
Range	Formula
G2:G4	G2	=IF(LEFT(C2,2)=LEFT(D2,2),E2*F2/2,0)
H2:H4	H2	=IF(LEFT(C2,2)=LEFT(D2,2),E2*F2/2,0)
I2:I3	I2	=IF(OR(LEFT(C2,2)<>LEFT(D2,2),D2="",C2=""),E2*F2,0)
J2:J5	J2	=SUM(G2:I2)+E2
I4:I5	I4	=IF(OR(D4="",C4=""),0,IF(LEFT(C4,2)<>LEFT(D4,2),E4*F4,0))
G5	G5	=IF(OR(D5="",C5=""),0,IF(LEFT(C5,2)=LEFT(D5,2),E5*F5/2,0))
H5	H5	=IF(OR(D5="",C5=""),0,IF(LEFT(C5,2)=LEFT(D5,2),E5*F5/2,0))

 

[maabadi]

You're welcome.
Don't forget to tick solve tick at right of best solution post.