Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

IF function for multiple cells and options [Closed]

Report
Posts
1
Registration date
Saturday December 23, 2017
Status
Member
Last seen
December 23, 2017
 -
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
 -
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

2 replies

Answer 1 / 2
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
 136
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.
Report

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?
Answer 2 / 2
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
 136
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
Ask a question