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)))
Practically the same
=SUM(--ISNUMBER(SEARCH({"PIN","CARD"},D6)))or, if return to initial formula
=OR(ISNUMBER(SEARCH("PIN",D6)),ISNUMBER(SEARCH("CARD",D6)))
Thank you for your assistance. The second option worked as how I was looking for the results to be. The first one gave a 0 return (as I would have guessed as a SUM function) and not a FALSE.
Thank you again for your help.
John
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
