Create a formula to rearrange different values in groups

[Raymond L]

In my excel spread sheet column K, named Age, contains different values
(years) for different residences. These values range from NEW (less than a
year) to 100 years old. I want to arrange, in a new column, these values in 3
groups.
Those ranging from 47 to 100 will be named 1.
Those ranging from 30 to 46 will be named 2.
Those ranging from NEW to 29 will be named 3.

 

[Max]

Assuming Age data is running in K2 down
Place in say, L2:
=IF(K2="","",IF(K2="New",3,VLOOKUP(K2,{0,3;30,2;47,1},2)))
Copy down

 

[FSt1]

hi
see if this will work for you.
=IF(A2="","",IF(A2>47,1,IF(A2>30,2,3)))

regards
FSt1