title: OR condition in a formula
body: <p>The below formula helps to Start from ASD and before the slash it prints all the data.</p>
  <p>Query:
  Now as per the requirement, i need to search for two words with OR condition.
  For eg it should either start with ASD or DEF I tried with OR condition but that is not working.
  Can someone pls guide in this.</p>
  <p>Working Formula:
  <code>=IF(ISNUMBER(SEARCH(&quot;ASD&quot;,A11)),MID(A11,SEARCH(&quot;&quot;&quot;&quot;,A11)+1,SEARCH(&quot;/&quot;,A11)-1-SEARCH(&quot;&quot;&quot;&quot;,A11)),&quot;&quot;)</code></p>
  <p>With OR Condition(which is not working)
  <code>=IF(ISNUMBER(SEARCH(&quot;ASD&quot;,A11) OR SEARCH(&quot;DEF&quot;,A11)),MID(A11,SEARCH(&quot;&quot;&quot;&quot;,A11)+1,SEARCH(&quot;/&quot;,A11)-1-SEARCH(&quot;&quot;&quot;&quot;,A11)),&quot;&quot;)</code></p>