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
|