Ageing bucket using if then else

[Dinesh_Excel]

Hello Friends,

I have a range of numbers where I need to group them as below :

Can you guys please help me with simple if then else statement

Appreciate your help

Condtions Remarks
Less than equal to 7 daysGreen
7 days to 30 DaysAmber
More than 30 daysGreen

 

[Hui]

assuming the value is in A2
=If(And(A2>7, A2<30),"Amber","Green")

 

[Hui]

If the last Green was meant to be Red
assuming the value is in A2
=If(A2>30,"Red",If(A2>7,"Amber","Green"))

 

[Dinesh_Excel]

Thanks Hui ..it helped me a lot
Appreciate your quick help..