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
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.
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.
Related:
- IF function for multiple cells and options
- Accessor function c++ - Guide
- How to lasso multiple objects in photoshop - Guide
- Sorry this function is temporarily unavailable clapper ✓ - Facebook Forum
- Find function on mac - Guide
- Spreadsheet function - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 24, 2017 at 06:42 AM
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.
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.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 25, 2017 at 07:33 AM
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
"...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
Dec 24, 2017 at 01:54 PM