Thanks - that did the trick. Although I did need to create another column
that had the =COUNTIF(range_to_search,"*CCT*") formula. I then referenced
this new column with a more simple if statement (i.e.
IF(A10,("CCT"),("CCO"))).

Is there a way to combine the logic you provided to do the wildcard search
for the string embedded in my initial IF statement? No worries if this is
really complicated.

Thanks again, Amanda

"Ron Rosenfeld" wrote:

On Sat, 4 Jun 2005 10:40:01 -0700, "Amanda Guenthner"
wrote:

Is there a way to structure IF statements to look for records that contain
certain text (i.e. like in SQL how you can do ? is like €˜%CCT%)?

Several methods:

=COUNTIF(range_to_search,"*CCT*") will return 0 if CCT is not present. (Note
the "*" wild card characters).

=FIND("CCT",G1) will return #VALUE! if CCT not present, otherwise it will
return a positive integer. (Note NO wild card characters allowed).

=SEARCH("CCT",G1) will do the same as FIND, but is case-insensitive.


--ron