IF function for multiple cells and options

BacktotheFuture 1 Posts Saturday December 23, 2017Registration date December 23, 2017 Last seen - Dec 23, 2017 at 01:34 PM - Latest reply: Mazzaropi 1697 Posts Monday August 16, 2010Registration dateContributorStatus January 20, 2018 Last seen
- Dec 25, 2017 at 07:33 AM
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.
See more 

3 replies

Reply to this topic
Mazzaropi 1697 Posts Monday August 16, 2010Registration dateContributorStatus January 20, 2018 Last seen - Dec 24, 2017 at 06:42 AM
0
Helpful
1
Backtothefuture, Good morning.

Please give us more information about your logic.

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.
backtothefuture - Dec 24, 2017 at 01:54 PM
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?
Respond to Mazzaropi
Mazzaropi 1697 Posts Monday August 16, 2010Registration dateContributorStatus January 20, 2018 Last seen - Dec 25, 2017 at 07:33 AM
0
Helpful
backtothefuture, Great Christmas morning.

"...Is there a way to calculate this based on TODAYs date instead of having to change it manually?..."
Of course there is a way.

I made a small example for you.
https://www.sendspace.com/file/u8me3y

Please tell us if this is what you wanted.
Hope this helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Respond to Mazzaropi