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 !
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 !
Is that a B and C are both blank or Either are Blank. Please clarify.
B and C are blank.. sorry.
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
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!
Thanks a lot for your feedback AND for YOUR Thanks
Don’t have an account yet? Register yourself now and be a part of our community!