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

H

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

Don Guillett

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

--
Don Guillett
SalesAid Software
(e-mail address removed)
hsg said:
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
Click to expand...
help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a Function 3
using an IF or AND function to get next largest value in list 1
Global Template Network and saving auto texts & macros 2
Need help finding a substring in a array of strings. 1
VLOOKUP text vs number issues returning value 13
Optional argument as Variant not acting like number 4
How to find a result in an array in the same row as a minimum resu 3
maxa function results in value error in worksheet 2

Top