Formula error

T

travelinman

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",)
 
M

Mike H

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
 
T

travelinman

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