Character

[Guest]

Hello,

I would like cell B1 to reference cell A1, and if cell A1 contains a "N"
within the cells text (multiple characters) then I would like cell B1 to give
a particular phrase otherwise give other text.

Thanks,

 

[Guest]

Hi tjh

Use the =FIND function nested within an =IF function.

Your check within the IF function should look for an #N/A return from the
FIND function.

Excel's help or textbooks should explain these well.

Regards

Phil

 

[Bob Phillips]

=IF(ISNUMBER(SEARCH("N",A1)),"phrase 1","phrase2 ")

--
HTH

Bob

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

 

[Dave Peterson]

=if(countif(a1,"*N*")>0,"it's there","it's not there")
or
=if(isnumber(search("n",a1)),"it's there","it's not there")
or
=if(isnumber(Find("N",a1)),"it's there","it's not there")

=find() is case sensitive.
=search() is not case sensitive.
The =countif() is not case sensitive, too.

 

[Guest]

Is this what you mean? I get a Value error with this. Not sure what I am
doing wrong.
=IF(ISNA(FIND("N",A1)),"NO N",FIND("N",A1))

Thanks,

 

[Guest]

Apologies I should have suggested checking for #Value! rather than #N/A!

=IF(ISERR(FIND("N",UPPER(A1))),"No N","N")

I've also added UPPER, this will find "n" and "N".

Regards

Phil