Worksheet Funct testing for #VALUE!

[Err]

Is there a worksheet function that I can test "find" for "#VALUE!"

Example =find("blah", "blahblah", 1) is "1"

But =FIND("argh", "blahblah", 1) is "#VALUE!"

How can I test this?

 

[Aladin Akyurek]

ISNUMBER(FIND(...))

 

[Err]

Of course. the inverse of my question

Danka

 

[bobinnc]

You can test for several types of errors using "ISERR":

=IF(ISERR(FIND("argh", "blahblah", 1)),"",FIND("argh", "blahblah", 1))

 

[Scott Huish]

bobinnc:

There is no need for ISERR, FIND will either return a number if it found it or a #VALUE! error if it didn't, so all you need to check for is to see if it returned a number or not.