title: How do I use the "IF statement" to select numbers from a range?
body: <p>I have a set of measurements ranging from 1 to 30. Any number between 1 and 10 is &quot;Good&quot;, any number between 11 and 24 is &quot;Mild&quot; while any number from 25 to 30 is &quot;Bad&quot;. I hope to use the IF statement to do this classification but I have am yet to get it right. I have tried the following:</p>
  <pre><code>=IF((1&lt;=A2&lt;=10),&quot;Good&quot;,IF((11&lt;=A2&lt;=24),&quot;Mild&quot;,IF(A2&gt;=25,&quot;Bad&quot;)))
  </code></pre>
  <p>I would appreciate your kind suggestions on the most effective way to get this done.</p>