IF testing for text

  • Thread starter Thread starter Dan E
  • Start date Start date
D

Dan E

In a formula, is there a way to to do a logical IF test on the contents of a
cell to see if the cell contents includes a known string (e.g. "TT")?
TIA

Dan
 
In a formula, is there a way to to do a logical IF test on the contents of a
cell to see if the cell contents includes a known string (e.g. "TT")?
TIA

Dan
Click to expand...

One way looking at the contents of A1:

=IF(ISERR(FIND("TT",A1)),"TT not present","TT present")

The above is case sensitive. For a case insensitive version, use SEARCH
instead of FIND.

You may also use a cell reference for the string being searched for.


--ron
 
For a true or false return,
With the list in Column A,
And the string to look for entered in C1,
Enter this in B1, and drag down to copy:

=ISNUMBER(SEARCH($C$1,A1))
 
One more:

=if(countif(a1,"*" & "tt" & "*")>0, "foundit","not there")
or
=if(countif(a1,"*" & b1 & "*")>0, "foundit","not there")
 
Back
Top