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!!

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!!

I should have added that if you want it to be case sensitive change SEARCH to
FIND

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!!

=IF(ISNUMBER(SEARCH("RR",A1)),"Contains RR","No RR")


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Raja" wrote in message
...
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!!

=IF(COUNTIF(A1,"*RR*"),"Contains RR","No RR")


"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!!

Perfect

Thank you to all of you who contributed to answering this!!

=IF(COUNTIF(A1,"*RR*"),"Contains RR","No RR")
and =IF(ISNUMBER(SEARCH("RR",B3)),"Contains RR","No RR") get me the result
that I am looking for.

Can somebody please explain the various arguments we are using!!
Also if it not much of a problem, can you please resolve this for me?:
When I copy and paste the above mentioned functions to the blank cells below
then if there is any entry on the left hand cell then I am getting the
relevant result but if the cells are blank then I am getting No RR. I need
the result to be Blank until I enter a value in the left hand cell.

Many thanks!!

Raja


"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!!

=IF(B3="","",IF(ISNUMBER(SEARCH("RR",B3)),"Contain s RR","No RR") )

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Raja" wrote in message
...
Perfect

Thank you to all of you who contributed to answering this!!

=IF(COUNTIF(A1,"*RR*"),"Contains RR","No RR")
and =IF(ISNUMBER(SEARCH("RR",B3)),"Contains RR","No RR") get me the result
that I am looking for.

Can somebody please explain the various arguments we are using!!
Also if it not much of a problem, can you please resolve this for me?:
When I copy and paste the above mentioned functions to the blank cells
below
then if there is any entry on the left hand cell then I am getting the
relevant result but if the cells are blank then I am getting No RR. I
need
the result to be Blank until I enter a value in the left hand cell.

Many thanks!!

Raja


"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!!