How to find a character in a text string without creating an error?

[rizzo93]

I need to check when characters are and are NOT within a cell.

=IF(AND(FIND("<>"&"!",$G11),FIND("<>"&"^",$G11)),1,0)

G11 = !Project Planning

The first logic test will produce a TRUE, but instead of the second one giving a FALSE, it gives a #VALUE error.

I know I can do the reverse by doing this:

=IF(AND(FIND("!",$G11),FIND("^",$G11)),1,0)

But I still need to use other combinations of the formula when one character is present and the other is not.

Is there some way to not create an error without having to use IFERROR?

 

[JoeMo]

Try wrapping the FIND functions in the ISNUMBER function

 

[rizzo93]

Hi JoeMo,

Thanks! I made some other modifications, but the critical thing was indeed to wrap them in ISNUMBER.