Forum Discussion
Solved
ISNUMBER(OR(SEARCH not producing expected results.
I am not sure why this is not working. I an no expert so bare with me. I have a column of text entries. I can use =ISNUMBER(SEARCH("CARD",D6)) to get a result TRUE/FALSE but I need to extend that ...
Practically the same
=SUM(--ISNUMBER(SEARCH({"PIN","CARD"},D6)))or, if return to initial formula
=OR(ISNUMBER(SEARCH("PIN",D6)),ISNUMBER(SEARCH("CARD",D6)))
John, you are welcome. In Excel FALSE and zero are equivalent, you may use any of them in condition.
Yes. That is true. For this instance I needed a return of FALSE for visual reasons more so than anything. Thanks