handle #VALUE exception

A

Andis Cirulis

hey,

I`ve excel function

=SEARCH("LV-1";D2)

if search text LV-1 is not found - it returns #VALUE

how can I handle this #VALUE ?

=IF(SEARCH("LV-1";D2);"substring_found";"substring not found")

is not working (#VALUE returned in false case)

I believe this is simple, just cannot think of any solution..

Thanks,
Andis
 
V

vezerid

=IF(ISNUMBER(SEARCH("LV-1";D2));"substring_found";"substring not
found")

HTH
Kostis Vezerides
 
B

Bob Phillips

=IF(ISERROR(SEARCH("LV-1";D2));"substring not found";"substring found")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top