Based on Age specify Categorised into Age Range

[PamG]

Hello,

I hope this is simple one that I would like some help on, please.

I have a column where I have already calculated the age of my customer based on DoB etc. However, I would now like to place them into a specific Age Range, eg.see image below

 

Much thanks in advanced

[JosephSerpis]

Hi @PamG you would need to use a condtional formula to achieve your desired results. I mocked up an approach showcasing this.

[PamG]

Hello @JosephSerpis 

Thank so much for coming back to us. This worked a charm and helped me a great deal. 

Thanks and have a good evening.