Multiple Empty Cells

[Jes2181]

How do you write an IF statement where: if either of 2 cells is blank then the given formula will not be shown?

If A2 is blank or D2 is blank then B2+F2 is not shown in cell G2.

[alansidman]

If(Or(A2="",D2=""),"",B2+F2)

[FDibbins]

Hi and welcome to the forum

number of ways to do this, these are based on either cells being blank (as opposed to both have to be blank)...

=if(or(A2="",D2=""),"",your-formula)
=if(counta(A2,D2)<2,"",your-formula)

[Jes2181]

Thanks guys for the quick help it worked great!