Nov 26 2019 03:34 PM
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 to add a second value. So I have tried
=ISNUMBER(OR(SEARCH("PIN",D6),SEARCH("CARD",D6))) which returns only FALSE values and
=ISNUMBER(SEARCH(OR("PIN","CARD"),D6)) which also returns only FALSE values.
Where am I going wrong? Why is the OR not happening?
Thank you for your help.
John
Nov 26 2019 06:45 PM
Nov 27 2019 12:58 AM
SolutionPractically the same
=SUM(--ISNUMBER(SEARCH({"PIN","CARD"},D6)))
or, if return to initial formula
=OR(ISNUMBER(SEARCH("PIN",D6)),ISNUMBER(SEARCH("CARD",D6)))
Nov 27 2019 08:03 AM
Thank you for the assistance. This gave an error when entered as not a formula.
Nov 27 2019 08:07 AM
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
Nov 27 2019 08:17 AM
John, you are welcome. In Excel FALSE and zero are equivalent, you may use any of them in condition.
Nov 27 2019 08:21 AM
Yes. That is true. For this instance I needed a return of FALSE for visual reasons more so than anything. Thanks
Nov 27 2019 12:18 PM
Nov 27 2019 12:58 AM
SolutionPractically the same
=SUM(--ISNUMBER(SEARCH({"PIN","CARD"},D6)))
or, if return to initial formula
=OR(ISNUMBER(SEARCH("PIN",D6)),ISNUMBER(SEARCH("CARD",D6)))