I have the following code in cell E2
A B C D E FALSE =IF(B2="FALSE","List1",IF(D2="FALSE","List2",""))
Here's how I read that formula: If the word "FALSE" is in cell B2, then put "List1" in E2, if the word "FALSE" is not in cell B2, then check to see if the word "FALSE" is in cell D2. If it is in D2, then put "List2" in E2, if not, then put nothing in E2.
Based on this, I'm expecting to see "List2" in E2 but instead E2 stays blank. So clearly my logic is wrong, but could someone help explain why and what I need to do to fix it? Thank you for looking.
Bookmarks