Maybe

=IF(ISERROR((SEARCH("RR",A1,1))),"No RR","Contains RR")

Mike

"Raja" wrote:

I want use the IF function to display "Contains RR" in a cell if the other
cells which has text that contains RR and "No RR" if the word doesn't contain
RR.

e.g.
A B
1 Carry =IF(A1=*RR*,"Contains RR","No RR")
2 Marry
3 Sweet
4 Harry
5 Sherry
6 Cry

This doesn't seem to work. Ids there any text function that I need to
combine with IF to get the result?

I don't want to use VBA because I don't know anything about it!!