| 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) | |||
Linear Mode
