PureBytes Links
Trading Reference Links
|
Possibly use the specific #VALUE! error test within the "search":
if (ERROR.TYPE(cell_ref)=3, true_cond, false_cond)
KL
> At 02:31 PM 01/02/2003, cwest wrote:
> >Can anyone suggest a solution when an Excel function returns #VALUE in a
> >condition. For example
> >
> >If(search("something",A1)>0, do something, do something else). If the
search
> >is successful "it" works, but if the search isn't true, then Excel
returns
> >#VALUE. I can't find a way to test for #VALUE.
> >
> >Thanks in advance
> >Colin West
>
> Use the ISNUMBER test which will return TRUE if its argument is a number
and FALSE if it is anything else, including the error you want to trap.
>
> =IF(ISNUMBER(SEARCH("something",A1)), 1, 0)
>
> HTH and HNY!
>
> Mike Gossland
>
>
|