Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Statements - Pick up Alpha Characters | Excel Discussion (Misc queries) | |||
Conditional If Statements | Excel Worksheet Functions | |||
Conditional statements | Excel Worksheet Functions | |||
Conditional Statements | Excel Discussion (Misc queries) | |||
The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) |