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

handle #VALUE exception
 

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

HTH
Kostis Vezerides


Andis Cirulis wrote:
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

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