# IFAND with blanks

• I'm using this formula ..

=IF(AND(B2="yes",C2<=DATEVALUE(2/19/2002)),"NO","YES")

How do I get it to not run this if the cells in B and C are blank ? So column D will just remain empty ..not a YES or a No?

Thank you !

• Hello and Welcome to the Forum

If my understanding is correct, you could test following :

Code
1. =IF(XOR(B2<>"",C2<>""),"",IF(AND(LOWER(B2)="yes",C2<=DATE(2002,2,19)),"NO","YES"))

Hope this will help

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner

• Basically what I'm trying to do is I have 4 conditions

If met and if date prior to 02/19/2002 than No.

If met date after 02/19/2002 than yes

if not met and date prior to 2/19/2002 than yes

If not met and date after 2/19/2002 than yes.

I got it to work but the issue is if I don't have "met" or "Date" filled in column D which the yes/ no is showing a YES. Sorry to ramble ... Don't know if I'm explaining that any better

• Thanks for the clarification ...

Are we getting closer ???

Code
1. =IF(OR(B2="",C2=""),"",IF(AND(B2="Yes",C2<=DATE(2002,2,19)),"NO","YES"))

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner

• That worked ! THANK YOU SO MUCH . I'm new to this so thank you for your patience!

• That worked ! THANK YOU SO MUCH . I'm new to this so thank you for your patience!