Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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",) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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",) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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",) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Error | New Users to Excel | |||
Formula Error | Excel Worksheet Functions | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
#REF error in formula | Excel Discussion (Misc queries) | |||
Error in a formula | Excel Discussion (Misc queries) |