If then statement with Great than and less than

[Ron Purpura]

Hello All
I thought I had the right formula, but here is what I am looking for

Column H contains age of patient. If age is less than 18 I want to return "0 to 18". Age greater than 18 but less than 65 return a "19 to 64" and age greater than 64 returns a ;'65 and Older"
Below is the formula, but cant quite figure out what is wrong. Any help is appreciated


=IF(H2<=18,"0 to 18",IF(AND(h2>18,h2<65),"19 to 64"),IF(H2>64,"65andOlder"))))

[Pete_UK]

As you have tested for age less than or equal to 18 in your first IF, you don't need to test for it again in your second IF. The formula can be simplified to:

=IF(H2<=18,"0 to 18",IF(H2<65,"19 to 64","65andOlder"))

Copy down as required.

Hope this helps.

Pete

[Ron Purpura]

Perfect ! Thank you Pete

[Pete_UK]

You're welcome - thanks for the rep.

Pete