Identify if Text is in that row and return True or False

[klmiura]

I have a worksheet that has several columns and I want a formula to identify
that row as true or false if it contains the following text: PAINM

I want to put this formula at the end of the row and just have it state
True if it is in that row or False if it is not.

Thanks
Karen

 

[T. Valko]

Let's assume the row is from column A to column L.

=COUNTIF(A1:L1,"PAINM")>0

 

[porter444]

=IF(COUNTIF(A1:L1,"PAINM")>0,"TRUE","FALSE")

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott

 

[klmiura]

I tried this and the first one that was suggested and it doesn't work. I
have a cell that has several other words in it including the PAINM would this
be the issue because it doesn't have just PAINM?

 

[Shane Devenshire]

Hi,

Try something like this

=SUMPRODUCT(--ISNUMBER(SEARCH("PAINM",A1:G1)))

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Shane Devenshire]

Hi,

I should add that my last solution is not case sensitive, for that use FIND
instead of SEARCH.

Cheers,
Shane Devenshire

 

[T. Valko]

would this be the issue because it doesn't have just PAINM?

Yes!

Try this:

=COUNTIF(A1:L1,"*PAINM*")>0

 

[klmiura]

XOXOXO..you are the best this worked great. Thanks so much and have a great
thanksgiving.