For SS only how about

=IF(ISERROR(SEARCH("SS",C6,1))=TRUE," ","N/A")

Can be modified for other searches
--
Gary's Student


"Newbie Bob" wrote:

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.