handle #VALUE exception

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andis Cirulis - 13 Nov 2006 11:09 GMT

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

Reply to this Message

vezerid - 13 Nov 2006 11:29 GMT

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

HTH
Kostis Vezerides

> hey,
>
[quoted text clipped - 14 lines]
> Thanks,
> Andis

Reply to this Message

Bob Phillips - 13 Nov 2006 11:32 GMT

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

Signature

HTH

Bob Phillips

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

> hey,
>
[quoted text clipped - 14 lines]
> Thanks,
> Andis

Reply to this Message