title: how to categorize values based on condition in excel
body: <p>I want to categorize my temperature data as:</p>
  
  <p><strong>very low</strong>: &lt;=15 Celsius</p>
  
  <p><strong>Low:</strong>:>=15 and &lt; 25 Celsius</p>
  
  <p><strong>normal</strong>:>=25 and &lt; 35 Celsius</p>
  
  <p><strong>high</strong>:>=35 and &lt; 45 Celsius</p>
  
  <p><strong>very high</strong>:>= 45 Celsius</p>
  
  <p>temp  category</p>
  
  <p>32<br>
  33<br>
  34<br>
  35<br>
  36<br>
  30<br>
  31  </p>
  
  <p>I have done something like this:</p>
  
  <pre><code>=IF(AND(a1&lt;15,OR(a1&gt;=15  a1&lt;=25),OR (a1&gt;25 a1&lt;=35) ,OR(a1&gt;35  a1&lt;=45) ,OR(a1&gt;45)),"Verylow","low","medium","high","veryhigh")
  </code></pre>
  
  <p>but it is not working. I want to fill values in category field. please help!!</p>