title: If else statement within formula using search
body: <p>How can I use if else statements within excel formula if I use search?
  For just comparing a cell to a value, it is pretty straight forward, but not with search.</p>
  
  <p>This is how I search if the there is a value in the cell:</p>
  
  <pre><code>=IF(ISNUMBER(SEARCH("AAA";L2)); "yes"; "no")
  </code></pre>
  
  <p>This would be the pseudo-code:</p>
  
  <pre><code>if (in cell L2 is BBB) {
  
   write "DONE!"
  
  } else {
  
   if (in cell L2 is AAA) { // this is what my formula already does !
    write "yes"
   } else {
    write "no"
   }
  
  }
  </code></pre>