IF statement to ignore "NULL"

[Shales]

Hi guys,

Another very simply formula I am sure....

I have this;

=IF(V2>$AJ$2,"Yes","No") AJ2 contains a static date

My problem is in column V, I have both dates (DD/MM/YYY) and NULL. My formula is currently returning "YES" when there is a NULL in column V.

How can the formula ignore NULL ?

Thank you.
Gavin

 

[Shales]

Was being silly guys. I worked it out.

=IF(AND(V2<>"NULL",V2>$AJ$2),"Yes","No")

 

[Mackers]

Do you mean the text "NULL" or a blank cell?

=ISBLANK() will return FALSE for a cell that contains a formula that returns "", so I tend to use =IF(LEN(V2)>0,

So for yours:

=IF(AND(LEN(V2)>0,V2>$AJ$2),"Yes","No")

This will return a "No" if the cell is blank. If you want to return a blank:

=IF(LEN(V2)=0,"",IF(V2>$AJ$2,"Yes","No"))

Edit: I'm glad you worked it out. I thought you meant a blank cell rather than the text "NULL", oops

Hope that helps

Mackers