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>
[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]cluster[/TH]
[TH]model[/TH]
[/TR]
</thead><tbody> [TR]
[TD]<=50[/TD]
[TD]K01[/TD]
[/TR]
[TR]
[TD]50-100[/TD]
[TD]K02[/TD]
[/TR]
[TR]
[TD]100-150[/TD]
[TD]K03[/TD]
[/TR]
[TR]
[TD]150-200[/TD]
[TD]K04[/TD]
[/TR]
[TR]
[TD]200-250[/TD]
[TD]K05[/TD]
[/TR]
[TR]
[TD]250-500[/TD]
[TD]K06[/TD]
[/TR]
[TR]
[TD]500-750[/TD]
[TD]K07[/TD]
[/TR]
[TR]
[TD]750-1000[/TD]
[TD]K08[/TD]
[/TR]
[TR]
[TD]1000-10000[/TD]
[TD]K09[/TD]
[/TR]
[TR]
[TD]>=10000[/TD]
[TD]K10[/TD]
[/TR]
[TR]
[TD]
my target
[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]210
[/TD]
[TD]??
[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]?/
[/TD]
[/TR]
</tbody>[/TABLE]

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.