Previous Topic Next Topic

IF function for multiple cells and options

Closed
BacktotheFuture Posts 1 Registration date Saturday 23 December 2017 Status Member Last seen 23 December 2017 - 23 Dec 2017 à 13:34
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 25 Dec 2017 à 07:33
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

Réponse 1 / 2
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
24 Dec 2017 à 06:42
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
24 Dec 2017 à 13:54
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?
Réponse 2 / 2
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
25 Dec 2017 à 07:33
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

Fill adjacent cell with number from text answer
MitchP -
vcoolio -

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

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
What Type does it want? (VBA question)
InsertNicknameHere -
TrowaD -

3 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses