title: How to categorize/classify numbers from different ranges using Excel?
body: <p>I want to categorize numbers from <strong>[0:15]</strong> into <strong>5</strong> classes: <code>A, B, C, D, E, F</code></p>
  
  <p><strong>Rules:</strong></p>
  
  <pre><code>0-1: Class A
  2-4: Class B
  5-7: Class C
  8-10: Class D
  11-13: Class E
  14-15: Class F
  </code></pre>
  
  <p><strong>Explanation:</strong> if number is in range <strong>[0:1]</strong> then it will be classified as <strong>A</strong>; if a number is in <strong>[2:4]</strong> class is <strong>B</strong>, and so on.</p>
  
  <hr>
  
  <p><strong>Sample output:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/Y0xDL.jpg" rel="nofollow"><img src="https://i.stack.imgur.com/Y0xDL.jpg" alt="enter image description here"></a></p>
  
  <hr>
  
  <p>I know it can be done with multiple <code>IFs</code>, but I have trouble figuring out what a formula will look like, epsecially distinguishing different number ranges. </p>