String function

I

Irina

Hi guys,

The problem is:

I need to know if a cell contains special text, if "yes" then d
something.

When I use "search" it returns "#VALUE!" if the result is FALSE and
do know how to avoid it.

Thanks a lot in advance,

Irina
 
F

Frank Kabel

Hi
try
=IF(ISNUMBER(SEARCH("special",A1)),"do something","do something else")
 
Top