Try this:
=IF(OR(ISNUMBER(SEARCH("ss",C3)),ISNUMBER(SEARCH(" bl1",C3))),"N/A","")
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Newbie Bob" <Newbie
wrote in message
...
I'm trying to make it so that when text is typed in a cell, other cells
will
read it, and if the text includes certain letters (like "ss" in "dssl" or
"ssdl") then it would insert "N/A" in the appropriate cells. i also want
it
to be able to look for more than one thing. Not case sesitive. Below is by
no
means code, but i don't know how else to explain it.
For instance in cell C14 (IF C3 = "*ss" or "*bl1" then "N/A" else " ")
I tried
=IF(SEARCH("SS", C6,1)0,"N/A", " ")
But it only worked if it were true, otherwise it errored, and only
satisfied
half my need.