Hello,

I'm trying to create a formula that will do the following:

IF cell A1 is not empty, then compare A1 to G1, if they're the same, return TRUE, if not return FALSE
IF cell A1 is empty, then compare B1 to G1, if they're the same, return TRUE, if not return FALSE

I have the following formula below but I'm getting incorrect data.

=IF(AND((AND(A1="",B153=G1)),"TRUE","FALSE"),IF((AND(A1<>"",A1=G1)),"TRUE","FALSE"))

Thanks for any help on this!

=IF(LEN(A1)>0,IF(A1=G1,"TRUE","FALSE"),IF(B1=G1,"TRUE","FALSE"))

Hi,

Try this:

=IF(A1<>"",A1,B1)=G1

HTH
Stu

Hi,

How about something like:

=IF(ISBLANK(A1),IF(A1=G1,TRUE,FALSE),IF(B1=G1,TRUE,FALSE))

Just my 2 cents...

EDIT: Oops... Sorry, I didn't see the previous replies before I posted. I like Stu's suggestion.

Thanks so much! It works!