Formula Help Please!

[Charles Williams-SC]

Hello Excel Experts!

Attached I have an example of what I am trying to accomplish. Simply put, I would like the cells in the "I" column to show a blank if A2 & D2 don't equal I1. I have tried every way I can think of (Except the correct way of course) and unable to get it to work.

Any help would be greatly appreciated.

 

[Gasman]

=IF(A2+D2<> I1,"",whatever you want here?) if you mean And as in math being plus?
=IF(A2&D2<> I1,"",whatever you want here?) if you mean And as in concatenation?
=IF(AND(A2<>I1,D2<>I1,),"",whatever you want here?) you mean to check each against I1 ?

had to use another cell for the concat version?

 

[Isaac]

I caught one more fish in this ocean of ambiguity!

=if(and(A2=TRUE,D2<>l1)

(for, in case you meant: IF A2=TRUE AND D2<>L1

Ok, I'm stretching it a bit here for fun

The point, @Charles Williams-SC , is this quote:

Words are our precision tools. Imprecision engenders ambiguity and hours are wasted in removing verbal misunderstandings before the argument of substance can begin

 

[arnelgp]

You forget to return "" when no condition is met:

=IF($A2=$I$1,$B2,IF($D2=$I$1,$C2,""))

 

[Charles Williams-SC]

Solution found!!! (Thank you Gasman).

=IF(AND(A2<>I1,D2<>I1,),"",whatever you want here?)

The only change I had to make is marked in red in the formula above. It seems that is an extra and unnecessary comma.

Thank you everyone for your help!

 

[arnelgp]

If Both a2 and d2 is equal to i1, same team compete to itself? Both are home / visitor team?

 

[Charles Williams-SC]

arnelgp NO, i'm sorry, I probably didn't make myself clear. It should be an either/or statement. If (A2) or (D2) = (I1)​

 

[Gasman]

arnelgp NO, i'm sorry, I probably didn't make myself clear. It should be an either/or statement. If (A2) or (D2) = (I1)​

Then my code should not work?
You would literally need OR()

 

[Charles Williams-SC]

Actually, your solution worked. The only change I had to make is marked in red in the formula below. It seems that there is an extra and unnecessary comma.

Your Solution
=IF(AND(A2<>I1,D2<>I1,),"",whatever you want here?)

My full formula
=IF(AND(A2<>$I$1,D2<>$I$1),"",IF(A2=$I$1,B2,IF(D2=$I$1,C2)))