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.

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.

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