Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
handling calculated excel cell error messages
When I try finding a text string within another test string (for exmaple
using "find" or "Search") it returns a value when the text string is found. However, when the text string is not found it returns an Error ("#Value!"). I'd like to autmatically calulate the cell as "Y" if the text string was found or "N" if it was not found. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
handling calculated excel cell error messages
Use instr inplace of find or before search
if instr(string1,",") 0 then 'put find or search here end if "RK" wrote: When I try finding a text string within another test string (for exmaple using "find" or "Search") it returns a value when the text string is found. However, when the text string is not found it returns an Error ("#Value!"). I'd like to autmatically calulate the cell as "Y" if the text string was found or "N" if it was not found. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
handling calculated excel cell error messages
=if(iserror(search(...)),"N","Y")
or: =if(isnumber(search(...)),"Y","N") RK wrote: When I try finding a text string within another test string (for exmaple using "find" or "Search") it returns a value when the text string is found. However, when the text string is not found it returns an Error ("#Value!"). I'd like to autmatically calulate the cell as "Y" if the text string was found or "N" if it was not found. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Handling #NUM! error | Excel Worksheet Functions | |||
Excel Error messages when making lables | Excel Discussion (Misc queries) | |||
Error handling in a search | Excel Discussion (Misc queries) | |||
I get error messages in Excel cells once I save a file | Excel Worksheet Functions | |||
Error handling in this code | Excel Discussion (Misc queries) |