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