IF function help

[toniplavna]

Hello,
I have a Excel 2016 and trying to complete some tutorial but i get formula error. I need to get this:

[FONT=&quot]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)

[FONT=&quot]HINT: Use the nested IF() functions. Alternatively, you can use the IFS() function if it is available in your version (2016 + updates from O365)

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>

 

[Osvaldo Palmeiro]

Hi. Try:

=if([@[Customer Age]]<25,"Youth",if([@[Customer Age]]<35,"Youth Adults",if([@[Customer Age]]<65,"Adults","Seniors")))

 

[toniplavna]

Hi. Try:

=if([@[Customer Age]]<25,"Youth",if([@[Customer Age]]<35,"Youth Adults",if([@[Customer Age]]<65,"Adults","Seniors")))

Thanks its working.
Can you tell me whats wrong with my function that I tried? Just want to better understand

 

[sunny102]

You have to include [@[Customer Age]] before <35 and <65

Thanks its working.
Can you tell me whats wrong with my function that I tried? Just want to better understand

 

[toniplavna]

ADVERTISEMENT

So it can be done with IF AND function, can you edit my function from the begining ?

 

[toniplavna]

I tried that, not working.

 

[sunny102]

Use this

=if([@[Customer Age]]<25,"Youth",if(and([@[Customer Age]]>24,[@[Customer Age]]<35),"Youth Adults",if(and([@[Customer Age]]>34,[@[Customer Age]]<65),"Adults",if([@[Customer Age]]>64,"Seniors"))))

I tried that, not working.

 

[toniplavna]

Thanks. I missed those ) after 35 and 65