Excel Find function: I want 0 if not found

[MRyerson]

I have a column that contains a long comment field.

I want a formula to tell me if a given set of characters exists in the comment field.

I don't care *where* the substring occurs, just does it occur, true or false.

Unfortunately the FIND function returns #VALUE! if the substring is not found.

Is there a way to "translate" the error value to a zero?

 

[bluedragon2]

IF(ISERROR(<find statement>),0,1)



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[mbarron]

The following would work.
=IF(ISERROR(FIND("text",A1)),0,FIND("text",A1))

Mike

 

[MRyerson]

Wow that was quick!

And, if had a bit more experience with Excel, I would have seen it.

Thanks!!

martyr