IF statement

[HS]

is there a way to say to create a column that displays a Yes or No if part of
a field has some text in it

for example if you wanted to tag the ones that had a D in column A

ColumnA Tag
abc N
abde Y
abcd Y
Thanks!

 

[Shane Devenshire]

Hi,

here are some other ideas:

=IF(COUNTIF(A1,"*d*")>0,"Y","N")

or

=IF(COUNTIF(A1,"*"&F1&"*")>0,"Y","N")

where F1 has whatever you want to search for

If you are willing to have the results display as True or False instead of
Y, N

=COUNTIF(A1,"*d*")>0

You can search for any string by just replacing the d with whatever..