IF statement
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..
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"HS" wrote:
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!
|