title: Excel Multiple If Statements showing False
body: <p>I have this IF statement:</p>
  
  <pre><code>=IF(AG3&lt;=7,"1",IF(15&lt;=AG3&lt;=21,"2",IF(22&lt;=AG3&lt;=28,"3",IF(29&lt;=AG3&lt;=35,"4",IF(36&lt;=AG3&lt;=42,"5",IF(43&lt;=AG3&lt;=49,"6",IF(50&lt;=AG3&lt;=56,"7")))))))
  </code></pre>
  
  <p>but either it gives me a 1 or "FALSE"</p>
  
  <p>All the values are within the ranges and should be showing various numbers</p>