Forum Discussion

Johancharmy's avatar
Johancharmy
Copper Contributor
May 11, 2020
Solved

Excel formula

I have 7 criteria ages groups, 0-1 Years, 2-4 Years, 5-12 Years, 13-18 Years, 19-30 Years, 31-59 Years, and 59+ Years. (1) Infants, (2) Toddlers, (3) Juniors, (4) Youth, (5) Y-Adults, (6) Adults, and...
Formulas and Functions
  • bhushan_z's avatar
    bhushan_z
    May 11, 2020

    =IF(A1>59,"Seniors", IF(A1>30,"Adults", IF(A1>18,"Y-Adults", IF(A1>12,"Youth", IF(A1>4,"Juniors", IF(A1>1,"Toddlers", "Infants"))))))

     

    Note: Change 'A1' to relevant reference cell in your worksheet

Johancharmy's avatar
Johancharmy
Copper Contributor
May 11, 2020

Thanks for coming back so soon. Doest seem to work !!!i have attached the error

bhushan_z's avatar
bhushan_z
Iron Contributor
May 11, 2020

seems like have made an error in number of brackets...
can u pls send screenshot of the formula in your worksheet?

  • Johancharmy's avatar
    Johancharmy
    Copper Contributor
    May 11, 2020

    Thankyou my friend

    • bhushan_z's avatar
      bhushan_z
      Iron Contributor
      May 11, 2020

      Johancharmy 

      Is it possible for you to share the file?

       

      Because it works perfectly in my system, refer below:

       

Resources