title: Any ideas how to determine what age group an individual belongs in Excel?
body: <p>I have 2 columns in an Excel spread sheet.</p>
  
  <p>First column header is called AGE and the second column header is called Age_Group.</p>
  
  <p>The ages in the AGE column are between 18 and 45.</p>
  
  <p>There could be multiple rows with same age.</p>
  
  <p>I am tasked with determining what age group a certain age falls into and then print out that age group.</p>
  
  <p>For instance, if someone’s age is 18, I would like to use IF statement or CASE statement to determine that age 18 is between 18 and 24 and then put that value into Age_Group column as 18-24.</p>
  
  <p>If age is 19, again, it will fall into the group of 18-24 in Age_Group column.</p>
  
  <p>If the age in the Age column falls between 25 and 29, then they will be in Age_Group column as 25-29.
  Here is an example:</p>
  
  <pre><code>AGE                            AGE_GROUP
  18                               18-24
  19                               18-24, 
  25                               25-29
  28                               25-29
  </code></pre>
  
  <p>If you would be kind to share some code, I can use it to calculate the rest till we reach 45.</p>
  
  <p>I am not good with Excel VBA. Any assistance with IF or CASE statement would be greatly appreciated.</p>