Multiple IF statement for radius mile

[richiebkerry]

Hello I have distance in my data that I would like to categorise into radial areas (The cell containing the distance is AN2). For example 10 and under is Area 1, 10.1 to 15 is Area 2, 15.1 to 20 is Area 3, 20.1 to 25 is Area 4 and anything greater than 25 is Area 5.

Any help would be greatly appreciated.

 

[Fluff]

Maybe
=IF(AN2<=10,"Area1",IF(AN2<=15,"Area2",IF(AN2<=20,"Area3",IF(AN2<=25,"Area4","Area5"))))

 

[richiebkerry]

Thank you very very much

 

[Fluff]

You're welcome