How to make cell Result as Blank, if one of sum of cells have no value

[pankajgrover]

How to make cell Result as Blank, if one of sum of cells have no value. In below example i want D3 and D4 should be result as blank until a3 and b4 have some values. Thanks

Shares Trading.xlsx
	A	B	C	D
1	Item	A	B	Total
2	pen	2500	3500	1000
3	pencil		5000	5000
4	rubber	4000		-4000
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=C2-B2

 

[wclaw]

You mean B3 and B4 have values?

=IF(ISNUMBER(B3),C3-B3, "")

 

[pankajgrover]

=IF(ISNUMBER(B3),C3-B3, "")

Thanks for reply, i want B3 or C3 both checking if have values, how to do ? =IF(ISNUMBER(B3 and C3) like that. In B3 have no values , and C4 hv no values, so i want it will check both column but how to do ?

 

[pankajgrover]

You mean B3 and B4 have values?

=IF(ISNUMBER(B3),C3-B3, "")

Shares Trading.xlsx
	A	B	C	D
1	Item			Total
2	pen	2500	3500	1000
3	pencil		5000
4	rubber	4000		-4000
Sheet4

Cell Formulas
Range	Formula
D2:D4	D2	=IF(ISNUMBER(B2),C2-B2, "")

After apply your formula, here C4 is blank now i want , D4 result should also be Blank.

 

[wclaw]

Cell D2 use following formula to check values in both cells B2 and C2
=SUMPRODUCT(--ISNUMBER(B2:C2))>1

 

[wclaw]

Cell D2 use following formula to check values in both cells B2 and C2
=SUMPRODUCT(--ISNUMBER(B2:C2))>1

sorry cannot edit, whole formula is

=IF(SUMPRODUCT(--ISNUMBER(B2:C2))>0,C2-B2, "")

 

[wclaw]

sorry cannot edit, whole formula is

=IF(SUMPRODUCT(--ISNUMBER(B2:C2))>0,C2-B2, "")

how can I edit my post?

=IF(SUMPRODUCT(--ISNUMBER(B2:C2))>1,C2-B2, "")

 

[etaf]

=IF(OR(B2="",C2=""),"",C2-B2)

Book2
	A	B	C	D
1	Item			Total
2	pen	2500	3500	1000
3	pencil		5000
4	rubber	4000
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=IF(OR(B2="",C2=""),"",C2-B2)

 

[pankajgrover]

Thanks to all members for helping me.

 

[etaf]

you are welcome