IF AND

[carl]

I am trying to write an IF formula that will evaluate as
true when looking through ColumnA for "APPLE" and ColumnB
for "NewYork".

Thank you in advance.

 

[Jason Morin]

=IF(SUM(COUNTIF(A:A,"*apple*")*COUNTIF(B:B,"*new*york*"))

0,TRUE)

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
maybe something like
=IF(AND(A1="APPLE",B1="NewYork"),TRUE,FALSE)