title: How to use If & AND formular for decimal in Excel?
body: <p>I have a column with several decimal numbers like:</p>
  <pre><code>A1: 0.48
  A2: 1.13
  A3: 4.31
  A4: 5.89
  </code></pre>
  <p>I want to find a number is in a specific set range. If yes give a specific letter out. I tried this formular but this doesnt work for decimal. For non decimal numbers it works well:</p>
  <pre><code>=IF(A1&gt;=10;&quot;A&quot;;IF(AND(A1&gt;=7;4.31&lt;=8);&quot;B&quot;;IF(AND(A1&gt;=4;4.31&lt;=3);&quot;C&quot;;IF(A1&lt;=0;&quot;D&quot;))))
  </code></pre>
  <p>But it shows for every number &quot;A&quot;. Why?</p>