Formula Help Please! (1 Viewer)

Charles Williams-SC

New member
Local time
Today, 13:33
Joined
Jul 13, 2020
Messages
10
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.
 

Attachments

  • Formula Help Please.zip
    7.4 KB · Views: 298

Gasman

Enthusiastic Amateur
Local time
Today, 17:33
Joined
Sep 21, 2011
Messages
14,044
=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?
 
Last edited:

Isaac

Lifelong Learner
Local time
Today, 10:33
Joined
Mar 14, 2017
Messages
8,738
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 :geek:

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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:33
Joined
May 7, 2009
Messages
19,169
You forget to return "" when no condition is met:

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

Charles Williams-SC

New member
Local time
Today, 13:33
Joined
Jul 13, 2020
Messages
10
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:33
Joined
May 7, 2009
Messages
19,169
If Both a2 and d2 is equal to i1, same team compete to itself? Both are home / visitor team?
 

Charles Williams-SC

New member
Local time
Today, 13:33
Joined
Jul 13, 2020
Messages
10
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)))
 

Users who are viewing this thread

Top Bottom