How to Refer to Error #Value! in an IF statement

  • Thread starter Thread starter Shiji
  • Start date Start date
S

Shiji

I am trying to use IF statement for a FIND function.

e.g. if you find a dot in the string, do this, if you do
not find a dot in the string, do that.

=IF(FIND(".",A1)>0, "Have dot", "No dot")

But FIND function returns error #VALUE! if it does not
find the value. Is there a way to refer to the return
error #VALUE!?

Thanks!
 
Try this:

=IF(ISERR(FIND(".",A1)),"No Dot","Have Dot")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am trying to use IF statement for a FIND function.

e.g. if you find a dot in the string, do this, if you do
not find a dot in the string, do that.

=IF(FIND(".",A1)>0, "Have dot", "No dot")

But FIND function returns error #VALUE! if it does not
find the value. Is there a way to refer to the return
error #VALUE!?

Thanks!
 
Back
Top