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!

 

[Guest]

try

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

 

[MrShorty]

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

 

[carlyman]

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

 

[MrShorty]

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