Formula error
 

The following formula returns a #Value! error message if the text "Update" is
not found. I tried using ISERROR and could not get it to work. I would like
to display a blank cell if th text is not found. Any ideas?

=IF(FIND("Update",C2)0,"x",)

Formula error
 

Hi,

Try this. Unless you have a reason for doing so use search instead of find
which is case sensitive

=IF(ISNUMBER(SEARCH("Update",C2)),"x","")

Mike

"travelinman" wrote:

The following formula returns a #Value! error message if the text "Update" is
not found. I tried using ISERROR and could not get it to work. I would like
to display a blank cell if th text is not found. Any ideas?

=IF(FIND("Update",C2)0,"x",)

Formula error
 

Thanks for being so quick Mike. Appreciate the effort. It worked fine and I
learned about the case sensitive feature.

"Mike H" wrote:

Hi,

Try this. Unless you have a reason for doing so use search instead of find
which is case sensitive

=IF(ISNUMBER(SEARCH("Update",C2)),"x","")

Mike

"travelinman" wrote:

The following formula returns a #Value! error message if the text "Update" is
not found. I tried using ISERROR and could not get it to work. I would like
to display a blank cell if th text is not found. Any ideas?

=IF(FIND("Update",C2)0,"x",)