nest IF formula
I want to use a formula to determine an age grouping
The groups are
16 up to 19
20 up to 24
25 up to 29
30 up to 34
35 up to 39 and so on until we get to 59 then it is Over 60
So if the cell has the age in, I want to put in the next cell the group it falls into, I thought an nested if statement would do that. I can do the first group as that will be <=19, and the last group would be >=60 but how do I do the betweens e.g 20 and 24 etc?
Whilst you could use a nested IF for this, it would be slow and cumbersome.
How about a lookup table as per the attached? It could be hidden away elsewhere in the workbook rather than be in plain sight.
You could try a vlookup. You would put the list of ages into an area beginning with the lowest age you expect to see (assuming 0) then the break point for each, say 0 to 15 would be <=15, then 16 and 19 would both be 16 up to 19, etc.
then where your ages are you use a vlookup and a TRUE instead of false and it will list each based on the age range you want.
EDIT: see attached.
Last edited by Sam Capricci; 04-02-2014 at 02:25 PM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you so much, much easier , I think I was over complicating it
Appreciate your quick reply and help
Thank you for your help much appreciated
You could look at this one too, this one lessens the # of rows you need to use for the vlookup.
BTW, if your issue is solved don't forget to mark your post as solved using the thread tools at the top of the post. And since you're new here, you can thank ALL who helped by clicking on "* Add reputation" below their posts, that is how we advance on this forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks