Feb 10 2012, 11:18 AM
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.
Thanks for any help on this!
Feb 10 2012, 11:20 AM
Feb 10 2012, 11:22 AM
Feb 10 2012, 11:23 AM
How about something like:
Just my 2 cents...
EDIT: Oops... Sorry, I didn't see the previous replies before I posted. I like Stu's suggestion.
Feb 10 2012, 11:25 AM
Thanks so much! It works!