Try

=IF(OR(ISNUMBER(FIND({"Super","Account","Business" },B96))),"OK", "Not OK")

--
Regards,

Peo Sjoblom


"Micayla Bergen" wrote in message
...
Hi i am using the following formula to find text in a cell
=IF(ISNUMBER(FIND("Super",B96)),"OK", "Not OK") and return a value. i have
adapted the formula for another spreadsheet and simply added more values
to
check, i.e. =IF(ISNUMBER(FIND("Super""Account""Business:,B96)) ,"OK", "Not
OK") but it doesnt seem to work. where i can see the value in the cell it
is
not returning ok instead of not ok. is there a limit to the number of
values
i can search and if so why doesnt it say as an error? what am i missing?
Thanks very much