Formula Help Please! (1 Viewer)

Charles Williams-SC

New member
Local time
Yesterday, 23:35
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: 8

Gasman

Enthusiastic Amateur
Local time
Today, 04:35
Joined
Sep 21, 2011
Messages
8,493
=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
Yesterday, 20:35
Joined
Mar 14, 2017
Messages
5,380
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

once i caught a fish alive...
Local time
Today, 11:35
Joined
May 7, 2009
Messages
13,192
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
Yesterday, 23:35
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

once i caught a fish alive...
Local time
Today, 11:35
Joined
May 7, 2009
Messages
13,192
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
Yesterday, 23:35
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