Double If conditions in Excel
In column A I have age in years count starting from 0 down to 94. In column B I need to have a formula that will separate age groups by two parameters: 1. I need age group 18 to 39; 2. I need age group 40 and older. Everything else is “not relevant”
Example: A1 = 57 will need B1= 40 and older
A2 = 18 will need B1 =18 to 39
A3 = 0 will need B1= not relevant
A4 = 25 will need B1 = 18 to 39
A4 = 65 will need B1 = 40 and older
Example: A1 = 57 will need B1= 40 and older
A2 = 18 will need B1 =18 to 39
A3 = 0 will need B1= not relevant
A4 = 25 will need B1 = 18 to 39
A4 = 65 will need B1 = 40 and older
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
One small correction I made to my posted solution, 30 should have been 39 in the text string for the middle option...
»bp
»bp
ASKER
that's alright! I noticed that too, but it's not a big deal:)
ASKER