Alpha conditional statements

[Dick W.]

*east does not find Northeast in the following formula:-
=if(a1="*east",a1,"")
What am I doing wrong?
Office XP
Thanks, Dick W

 

[Peo Sjoblom]

Try

=IF(COUNTIF(A1,"*east*"),A1,"")


--


Regards,


Peo Sjoblom

 

[Mike H]

Maybe

=IF(SEARCH("east",A1,1),A1,"")

Mike

 

[Peo Sjoblom]

That will throw an error if it doesn't find anything, you have to wrap it in
either ISNUMBER or ISERR/ISERROR


=IF(ISNUMBER(SEARCH("east",A1,1)),A1,"")


--


Regards,


Peo Sjoblom

 

[Dick W.]

Thanks Peo and Mike your help is much appreciated.
Dick W.