easy one....

[purplehaz]

I looked thru my notes and in the vb help, but I can't find it. Can someone
remind me again how to do this.
I need the code to do this:

If cell a1 and cell a2 = blank, then do something

It's the AND part I'm stuck on. How do I get it to only do the action if
cell a1 and a2 = blank?

Thanks alot.

 

[Peo Sjoblom]

=IF(COUNTBLANK(A1:A2)=2,"do something","don't do something")


or using AND

=IF(AND(A1="",A2=""),"do something","don't do something")

Regards,

Peo Sjoblom

 

[purplehaz]

That's what I was looking for. Thanks alot.

=IF(COUNTBLANK(A1:A2)=2,"do something","don't do something")


or using AND

=IF(AND(A1="",A2=""),"do something","don't do something")

Regards,

Peo Sjoblom