Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If one cell isnumber, and another has text,..
I have text in cell a1, including, but not limited to (FLM):
If I have a number, either 1 or 0 in cell B1 I need cell C1 to show FL if A1 contains FL And D1 to show M if A1 contains M A1 B1 C1 D1 abcdefg(FLM) 0 FL M Thanks, Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If one cell isnumber, and another has text,..
In C1 use: =IF(ISERROR(FIND("FL",A1)),"",IF(OR(B1=0,B1=1),"FL ",""))
In D1 use: =IF(ISERROR(FIND("M",A1)),"",IF(OR(B1=0,B1=1),"M", "")) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Steve" wrote in message ... I have text in cell a1, including, but not limited to (FLM): If I have a number, either 1 or 0 in cell B1 I need cell C1 to show FL if A1 contains FL And D1 to show M if A1 contains M A1 B1 C1 D1 abcdefg(FLM) 0 FL M Thanks, Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If one cell isnumber, and another has text,..
Worked like a charm. Thanks so much.
Steve "Bernard Liengme" wrote: In C1 use: =IF(ISERROR(FIND("FL",A1)),"",IF(OR(B1=0,B1=1),"FL ","")) In D1 use: =IF(ISERROR(FIND("M",A1)),"",IF(OR(B1=0,B1=1),"M", "")) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Steve" wrote in message ... I have text in cell a1, including, but not limited to (FLM): If I have a number, either 1 or 0 in cell B1 I need cell C1 to show FL if A1 contains FL And D1 to show M if A1 contains M A1 B1 C1 D1 abcdefg(FLM) 0 FL M Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|