handle #VALUE exception
=IF(ISERROR(SEARCH("LV-1";D2));"substring not found";"substring found")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Andis Cirulis" wrote in message
...
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
|