Share via

Excel nested iff statement

Anonymous
2017-02-15T12:24:55+00:00

I am trying to write an iff statement that will answer the following criteria

I have the birthdates of our employees and want to group them in generation categories. 

I'm having trouble with the => and between groupings

Generation Z:  1996-present

Millennials:  1977-1995

Generation X:  1965-1976

Baby Boomers:  1946-1964

Traditionalists:  Pre-1946

thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-02-15T18:52:51+00:00

    Hi Trad,

    Greetings from a baby boomer.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-02-15T13:39:31+00:00

    Here are a couple of ideas.

    In column C

    =IF(YEAR(A2)<1946,"Trad",IF(YEAR(A2)<1965,"Boomer",IF(YEAR(A2)<1977,"GenX",IF(YEAR(A2)<1996, "Millenial","Gen Z"))))

    In column E

    =LOOKUP(YEAR(A2),{0,1946,1964,1976,1995},{"T","B","X","M","Z"})

    best wishes (I'm very much a Trad!)

    Was this answer helpful?

    0 comments