title: Check cell for a specific letter or set of letters
body: <p>In a Google Spreadsheet, I want to use a formula that will output a certain text or number if a certain cell contains certain letters.</p>
  
  <p>For example, if I put <code>=IF(A1="Black";"YES";"NO")</code> and A1 is equal to "Black" - it outputs "YES" correctly.  However when I put <code>=IF(A1="Bla";"YES";"NO")</code> it outputs "NO".  Is there any formula that I can use that I can say something like <code>=IF(A1 CONTAINS "Bla";"YES";"NO")</code> so it outputs "YES".</p>