IF question
By nesting a SEARCH function inside the IF, you can do what you need:
=IF(SEARCH("office",AC21,1)0,"Yes","No")
SEARCH looks for the string "office" in cell A21 and returns its
position in the string if it is there, or zero if it is not. SEARCH is
similar to FIND, but SEARCH is not case sensitive, where FIND looks
for an exact case match.
Have a good weekend!
Dave O
|