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

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

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