Check for "#VALUE!"

C

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!
 
M

MrShorty

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

carlyman

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