Check for "#VALUE!"
 

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

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

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


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=379062

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


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=379062

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


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=379062