excel formula for if 2 new conditions are satisfied

[vas6566]

Hi, HAPPY NEW YEAR. I have come back to you after 2019 with a mild hiccup in creating one excel formula perfectly. Hope you can resolve it. I need a suitable formulae for the following subject.

IF cell B3 contains the value "A", at the same time only if cell H3 has a value greater than zero, it should return D3+E3-G3. that is if H3 has no value or its value is less than zero, no result is required. Here 2 conditions need to be fulfilled, the value in B3 should be exactly "A" and at the same time value in H3 should numeric value more than 0, if these two conditions are satisfied i need the value of D3+E3-G3, if these two conditions are not satisfied no value is required in the formula cell ( not necesary to add D3 and E3 and less G3 ). The following table may be self explanatory. pls respond , thank in advance

PARTICULARS	UNIT	Net Block as per B/S- 01.04.2022	Gross Block_AYM_ 1.4.2022	Additions	Dep	Deletions	Net Block as per B/S- 31-03-2023	Gross Block_AYM_ 31.03.2023	Result if formula is correct
Building-Hosur	A	3,84,745.00	500000	1000		0	3,85,745.00	formula required	501000
Factory-Ayanambakkam New Building	A	9,44,195.04	1500000	55000		0	9,00,195.00	formula required	1555000
Factory Buildg - (Mogappair A10 & B8)	M	94,60,755.00	0			0	94,60,755.00	formula required	0
Factory Building-Ayanambakkam - Old	A	1,90,120.00	1140000			190120	-	formula required	0
Factory- Building- Sipcot, Vallam	A	25,50,000.00	3000000	200000		50000	27,00,000.00	formula required	3150000

 

[Joe4]

Try:

=IF(AND(B3="A",H3>0),D3+E3-G3,"")

 

[vas6566]

Try:

=IF(AND(B3="A",H3>0),D3+E3-G3,"")

Hi, thanks a lot, it works perfectly. Really this a great help to the community. Thank you so much. please let me know what does the symbol , "") mean at the end of the formula.

 

[Joe4]

Hi, thanks a lot, it works perfectly. Really this a great help to the community. Thank you so much. please let me know what does the symbol , "") mean at the end of the formula.

You are welcome.

Every IF formula has 3 parts to it:
=IF(condition, what to return if condition is true, what to return if condition is false)

"" is just an empty string. So we are telling it to return the empty string if your condition is not satisfied, as you requested.

if H3 has no value or its value is less than zero, no result is required.

 

[vas6566]

You are welcome.

Every IF formula has 3 parts to it:
=IF(condition, what to return if condition is true, what to return if condition is false)

"" is just an empty string. So we are telling it to return the empty string if your condition is not satisfied, as you requested.

Very very clear explanation.