Edit IF statement

[djl0525]

I have a formula in D2. It works fine. I'm about to copy it down the column and I only want it to evaluate if E2 is not blank.

I need help prefacing the statement with "if E2 is not blank". I think it's something like IF(E2<>""... and that's where I'm stuck.

Can you edit this IF statement for me please?

=IF(COUNTIF(Accounts!B:B,E2)=0,"Account Not Found",COUNTIF(Accounts!B:B,E2))

Thanks - DJ

 

[Momentman]

Something like this

=IF(E2<>"",IF(COUNTIF(Accounts!B:B,E2)=0,"Account Not Found",COUNTIF(Accounts!B:B,E2)),"")

 

[djl0525]

Perfect! I see what I was doing wrong. Thanks so much, Momentman!

DJ

PS. Did you see my latest post in this thread? I could sure use your help with this! http://www.mrexcel.com/forum/excel-...c-applications-enter-date-a2.html#post3900940