It is meant to, and does work, on text. Using your data in later post, it is

=IF(SUMPRODUCT(--(ISNUMBER(FIND({"SS","RL","DMD","DMM","DMS","DRS"} ,C6))))0
, "N/A", " ")

which is far more maintainable than the nested IFs.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Newbie Bob" wrote in message
...
Since my user input was text, this formula didn't work for me, but thanks
for
the efforts!

"Bob Phillips" wrote:

or a SUMPRODUCT

=IF(SUMPRODUCT(--(ISNUMBER(FIND({"a","b","c","d","e","f"},C6))))0,
"N/A", "
")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Zack Barresse" wrote in message
...
Well, you could always nest AND statements ...



=IF(AND(ISERR(FIND("a",A1,1)),ISERR(FIND("b",A1,1) ),ISERR(FIND("c",A1,1)),IS
ERR(FIND("d",A1,1)),ISERR(FIND("e",A1,1)),ISERR(FI ND("f",A1,1))),"Not
Found","OK")

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the
board, as
to benefit others.




"Newbie Bob" wrote in message
...
I have a task list of things that need to be done on RMA's.
what I want to do is have a cell where the user inputs a model
number or
description (perhaps 6 choices), then the cells that don't apply to
that
part
number would display an N/A

=IF(SEARCH("SS", C6, 1)0, "N/A", " ") works only for words
containing
ss,
anything else creates an error.

=IF(C6="SS", "N/A", " ") works only if the input is ss

Any help would be greatly appreciated.

Thanks.