toniplavna
New Member
- Joined
- Dec 25, 2016
- Messages
- 10
Hello,
I have a Excel 2016 and trying to complete some tutorial but i get formula error. I need to get this:
[FONT="]Next, let's add an "Age Group" column. Insert a new column to the left of the Customer Gender, and use formula to derive the age group from the Customer Age column. Let's group the customers based on the following criteria:[/FONT]
So I wrote:
=if([@[Customer Age]]<25,"Youth",if(and([@[Customer Age]]>24,<35,"Youth Adults",if(and([@[Customer Age]]>34,<65,"Adults",if([@[Customer Age]]>64,"Seniors"))))
Not working... I think that problem is when i have 2 requirements like >24,<35, something there is wrong :/ Help[/FONT]
****** id="cke_pastebin" style="position: absolute; top: 274.578px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">requirement</body>
I have a Excel 2016 and trying to complete some tutorial but i get formula error. I need to get this:
[FONT="]Next, let's add an "Age Group" column. Insert a new column to the left of the Customer Gender, and use formula to derive the age group from the Customer Age column. Let's group the customers based on the following criteria:[/FONT]
- Youth (<25)
- Young Adults (25-34)
- Adults (35-64)
- Seniors (>64)
So I wrote:
=if([@[Customer Age]]<25,"Youth",if(and([@[Customer Age]]>24,<35,"Youth Adults",if(and([@[Customer Age]]>34,<65,"Adults",if([@[Customer Age]]>64,"Seniors"))))
Not working... I think that problem is when i have 2 requirements like >24,<35, something there is wrong :/ Help[/FONT]
****** id="cke_pastebin" style="position: absolute; top: 274.578px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">requirement</body>