# Formula Help Please! (1 Viewer)

#### Charles Williams-SC

##### New member
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

7.4 KB · Views: 8

#### Gasman

##### Enthusiastic Amateur
=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
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

##### once i caught a fish alive...
You forget to return "" when no condition is met:

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

#### Charles Williams-SC

##### New member
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...
If Both a2 and d2 is equal to i1, same team compete to itself? Both are home / visitor team?

#### 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

##### New member
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.

=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)))

Replies
5
Views
68
Replies
12
Views
353
Replies
13
Views
201
Replies
13
Views
122
Replies
1
Views
139