[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel function



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