Alpha conditional statements
 

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

Alpha conditional statements
 

Try

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


--


Regards,


Peo Sjoblom

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

Alpha conditional statements
 

Maybe

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

Mike

"Dick W." wrote:

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

Alpha conditional statements
 

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

"Mike H" wrote in message
...
Maybe

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

Mike

"Dick W." wrote:

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

Alpha conditional statements
 

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

"Peo Sjoblom" wrote:

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

"Mike H" wrote in message
...
Maybe

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

Mike

"Dick W." wrote:

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