Clustering Number Then Convert in "Model"

[muhammad susanto]

hi all..

how to clustering this number below then convert in "model"
like this layout :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>

cluster	model
<=50	K01
50-100	K02
100-150	K03
150-200	K04
200-250	K05
250-500	K06
500-750	K07
750-1000	K08
1000-10000	K09
>=10000	K10
my target
210	??
500	?/

<thead>
</thead><tbody>
</tbody>

any help greatly appreciated..

.sst

 

[Special-K99]

Do you mean like this?

="K"&LOOKUP(A1,{0,50,100,150,200,250,500,750,1000,10000},{"01","02","03","04","05","06","07","08","09","10"})

where A1 is your input number.