IF with many conditions

[sburkhar]

I need to write a formula that states:

If the cell is empty then nothing
if it contains "terminal" then "Term"
if it contains "wire"" then "wire"
if it contains anything else then "other".

but the cell will contain something like this:

70031171 Terminal;BC;Press/Lug/Tab/Pipe

so the formula will need to select the word "Terminal" out of the string of words to return "term" "wire" or "other"
Excel 2003

 

[texasalynn]

MrKowz,

I ran the formula through the evalator and see that having Terminal in A1 generated a 1 so returned Term....why does it return a 1?

because it is doing a search for the "Terminal" and found it as the 1st character. Search will return a number at the number of characters placement. If you have Bus Terminal then it would have returned 4. Make sense?

 

[Dryver14]

Thanks Texasalynn,

It does, having played with it I posted another question

 

[sburkhar]

I'm lost...........