title: If cell begins with 'z' then 'Q' else 'A'
body: <p>I want to check if the value of cells B5 to the last row in column B begins with a lowercase z.  If so I want to set value of column S for that given row to Q, if the value of column B begins with any other character I want the value of column S to be A.  Here's what I've tried that is not working...</p>
  
  <pre><code>Range("S5:S" &amp; lRow).Formula = "=IF(LEFT(B5,1)=""z"",""Q"",""A""))"
  </code></pre>