Check for "#VALUE!"

[carlyman]

I know it is possible to do by writing a script....but is there a way to check if a function returns "#VALUE!" logically?

Simple example:
SEARCH("e","1234") returns #VALUE!.
I'd like to say IF(SEARCH("e","1234")="#VALUE!","ERROR","No Error")

Thanks!

[MrShorty]

Would the ISERROR function serve your purpose, or do you need to distinguish the #VALUE error from other errors?

[Duke Carey]

try

=if(iserr(search(...)),"Error","No error")

"carlyman" wrote:

>
> I know it is possible to do by writing a script....but is there a way to
> check if a function returns "#VALUE!" logically?
>
> *Simple example: *
> SEARCH("e","1234") returns #VALUE!.
> I'd like to say IF(SEARCH("e","1234")="#VALUE!","ERROR","No Error")
>
> Thanks!
>
>
> --
> carlyman
> ------------------------------------------------------------------------
> carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
> View this thread: http://www.excelforum.com/showthread...hreadid=379062
>
>

[carlyman]

I can work around it using ISERROR, but I was hoping to implement something more based on what type of error it was.

[MrShorty]

In that case, there's the ERROR.TYPE function.