Previous Topic Next Topic

IF function for multiple cells and options

Closed
BacktotheFuture Posts 1 Registration date Saturday December 23, 2017 Status Member Last seen December 23, 2017 - Dec 23, 2017 at 01:34 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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.

2 responses

Answer 1 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Dec 24, 2017 at 06:42 AM
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?
Answer 2 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Dec 25, 2017 at 07:33 AM
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to create two WhatsApp accounts on a Windows PC?
Lason -
talha007 -

3 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Cannot download multiple files at once in WhatsApp Web
nemonavicusrino -
dannygzus -

4 responses
Name Values
brendanconlin -
TrowaD -

1 response