Test for #VALUE! in a cell

  • Thread starter The original Lisa Pease
  • Start date
T

The original Lisa Pease

I want to use SEARCH to find a string (a) within a string (b), but if
the string is not there (a not in b), I want the cell to display a
blank or zero, not "#VALUE!". Is there a way to test for #VALUE! such
that I could include in an IF statement (if #VALUE! then show 0)?
Thanks.
 
P

Peo Sjoblom

=IF(ISNUMBER(SEARCH("string",A1)),Formula,"")

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top