handle #VALUE exception
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
|