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.
|