title: Why is the Find function returning "#Value" when the statement returns False?
body: <p>I am trying to write a find function, and the [value_if_true] is given "Yes" and [value_if_false] is given "No". Here's the simple code:</p>
  
  <pre><code>=IF(FIND("T",B2),"Yes","No",)
  </code></pre>
  
  <p>Cell B2 contians "Apples" If I put "A" into the first part of the "FIND" function, the function returns "YES", as it should. But when I put "T" or anything that is not in the word "Apples", it returns #VALUE. I do not know why. Any ideas?</p>
  
  <p>Thanks!</p>