title: Ms Excel IF ISNUMBER SEARCH for multiple text using AND or OR operator
body: <p>This is my excel data</p>
  
  <p><a href="https://i.stack.imgur.com/ygqld.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ygqld.jpg" alt="enter image description here"></a></p>
  
  <p>As you can see in <code>B2</code>, this formula only search for the first text it found and will ignore the rest.</p>
  
  <p>What I'm trying to accomplish is if 2 or more different texts are found like <code>B2</code>, is it possible to print another message ... let say <code>Apple &amp; Banana found</code></p>
  
  <p><a href="https://i.stack.imgur.com/4xT0v.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4xT0v.jpg" alt="enter image description here"></a></p>
  
  <p>This is my original excel formula for your reference:</p>
  
  <pre><code>=IF(ISNUMBER(SEARCH("apple",A2)),"Apple",
  IF(ISNUMBER(SEARCH("banana",A2)),"Banana",
  IF(ISNUMBER(SEARCH("cher",A2)),"Cherries",
  "Other")))
  </code></pre>