How to avoid #VALUE error in FIND function if an asked argument i.

[hsg]

I try to find a word in given text and print a value based on whether the
word is conatined in given text or not. If the word is not there, I wish to
print some message elsewhere in worksheet saying that the given word is not
there in the given text. But FIND and SEARCH result in #VALUE error since the
desired word is not present in given text. HOw to overcome this? Please help.

 

[Don Guillett]

have a look at iserr or other error functions.
=IF(ISERR(FIND("xdd",C1)),"",FIND("xdd",C1))

--
Don Guillett
SalesAid Software
[email protected]

I try to find a word in given text and print a value based on whether the
word is conatined in given text or not. If the word is not there, I wish to
print some message elsewhere in worksheet saying that the given word is not
there in the given text. But FIND and SEARCH result in #VALUE error since the
desired word is not present in given text. HOw to overcome this? Please

help.