IF AND Statement help

[rguss985]

I need help formatting a formula. I want to check to see if a single cell is = a value and if a series of cells contain a certain value.

IF(AND(A1 = TEST, (B1:H1, "*S2*"),"Testing","")

I am fuzzy on the second condition. Any help would be great. Thanks!

[vlady]

maybe like this

=IF(AND(A1="TEST",COUNTIF(B1:E1,"*S2*")>0),"Testing","")

[benishiryo]

hi rguss985, welcome to the forum. your eg may be a bit too vague. uploading a sample Excel file will enable us to help you better. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon
ideally, it should contain your desired results

is TEST a Named cell or do you want to find if A1 has the text "TEST"? if it's the former, maybe:
=IF(AND(A1=TEST,COUNTIF(B1:H1,"*s2*")=COLUMNS(B1:H1)),"Testing","")
or if it's the latter, then:
=IF(AND(A1="Test",COUNTIF(B1:H1,"*s2*")=COLUMNS(B1:H1)),"Testing","")

also not sure if the counts in B1:H1 should just contain 1 or all cells must contain S2

[rguss985]

That worked. Thank you SO SO muh!!