|
PureBytes Links
Trading Reference Links
|
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
|