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