Using IFAND Statements

Hello,
I am trying to do a quick validation which requires a look to see if data is in A1 then data should be in A2 - and if nothing in A1 then nothing should be in A2.

I know this should be easy - but I am at a loss.

Any suggestions would be GREATLY appreciated!!!

Thanks!
Lisa

Sorry I was not clear. A1 is a date (say of return) and A2 is the reason code for the return (say wrong size). So, I want to validate that if there is a date in A1 there is also a reason code in A2 - but if there is no date in A1 then A2 should also be blank.

Thanks!
Lisa

This is sooooo close ... the only thing I am missing is that I want it to tell me that it is also OK if there is no date and no reason code (currently is coming back with "#VALUE").

Thank you for all of your help -- I would have NEVER gotten to that code on my own!!!

It is still bringing back "#VALUE" where both cells are blank...

Hi

If the date is in A1 then in A2 how about:

Formula:

Please Login or Register  to view this content.

Yes - still an error result - but I don't see any differences between the last attachment and the previous code...

This is close as well ... but does tell me "wrong size" when there is a date but no reason code. I just want it to validate if there is a date then there is also a reason code ... so it is OK to not have both - but if one of them (i.e. date or reason code) is present then they should both be present.

That's it! THANK YOU for all of your help!!!

This works too - thanks!