How do I work around getting a #VALUE! error when the SEARCH function does not find the text string? I want to nest the SEARCH function in an IF statement, and the "if false" part won't work. Because the function returns the #VALUE! error instead of "FALSE" OR "0" I can't assign a zero as the value, if the text is not found. And because of this, I cannot SUM the results in a whole column, because although some values return what I assign for results that are TRUE, some of the values returned are errors.
Example:
=IF(SEARCH("/",H5,1) > 0, 1, 0)
So if any slashes are found, I want a 1. If no slashes are found, I want a 0. Instead, I get a 1 or #VALUE!, which screws up my whole grand total.
I'd really appreciate a work around. Thanks!!!!!!
Bookmarks