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 |