If Range Contains Text

[The_Rock]

Hi Folks
Can you please help me update the following or suggest something new to try instead.

I have data in columns H to W.

Currently, I am using the below which is working fine

=IF(COUNTIF(H3:W3,"FAIL SVI VAP"),"Failed SVI Cert Element","")

I would like to update this to include OR. I've tried inserting it in different places but can't get it to work.
Basically, I need:

If the Range H3:W3 is either "Fail SVI VAP" OR "Fail ALL", then "Failed SVI Cert Element" else ""

Thanks in advance

 

[Jonmo1]

Perhaps..

=IF(COUNTIF(H3:W3,"FAIL*"),"Failed SVI Cert Element","")


However, technically this is only saying if the value begins with Fail.
so it would count any row that begins with Fail, not JUST the 2 you instances you indicate..

 

[Jonmo1]

If you need to be more specific than that..then try

=IF(SUM(COUNTIF(H3:W3,{"FAIL SVI VAP","Fail ALL"})),"Failed SVI Cert Element","")

 

[The_Rock]

Hi Jonmo1
I don't want to use wildcards as I have another 2 fail criteria which I do not want to include.

Any other suggestions?

 

[The_Rock]

Thanks, that did the trick!!

I love this forum!!

 

[Jonmo1]

Glad to help. Thanks for the feedback.