Hi, I'm trying to use the IF function but even when I copy a formula, I can't seem to get the correct answer. I thought it might be because the cell was formatted to text or something else but it wasn't that. Could somebody lend me a hand please?
I need to calculate age ranges from different cells. So if A2, C2 or E2 are between January 1, 2000 and December 31, 2012, the age group should be 5-17 years. If A2, C2, or E2 are less than January 1, 2000, the age group should be 17+. If A2, C2, or E2 are greater than December 31, 2012.
As you say any of the three cells can contain the IF clause, what happens if A2 <01/01/2000 and C2 is between 01/01/2000 and 12/31/2012 and E2> 12/31/2012?
What will be the response group?
We need to know how your layout is to help you faster and more conclusively.
Thank you for your prompt message. The information is for children's age ranges. One row per family and there will be up to 3 children's dates of birth. Sorry, I don't think I had this organized enough, I have changed the idea. Let me see if I can clarify: If A2 is a date of birth, the response should be either below 5 years, 6-17 years old and 17+. Is there a way to calculate this based on TODAYs date instead of having to change it manually?