Full Version: Nested Ifs
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
tiger3p
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!
ipisors
=IF(LEN(A1)>0,IF(A1=G1,"TRUE","FALSE"),IF(B1=G1,"TRUE","FALSE"))
StuKiel
Hi,
Try this:
=IF(A1<>"",A1,B1)=G1
HTH
Stu
tiger3p
Thanks so much! It works!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.