title: VBA Program does not give the correct text when statement is false
body: <p>My program is suppose to see if the length of the text is within 1 to 31. </p>
  
  <p>If the length is not within 1 to 31 it will return a "FALSE" at e28. </p>
  
  <p>My problem is no matter the length of the text, <strong>it always returns a "TRUE"</strong> please enlighten me on why this is happening.  </p>
  
  <pre><code>x = Range("b26").Value
  
  count = Len(x) - Len(Replace(x, "-", ""))
  
  If Len(x) - count &gt; 1 &amp; Len(x) - count &lt; 32 Then
      MsgBox Len(x) - count
      Range("e28").Value = "TRUE"
  Else
      Range("e28").Value = "FALSE"
  End If
  </code></pre>