Wigi wrote:
Hi Ivica

If you setup a simple table, the VLOOKUP function will do it.

First column of the table has all the cutoff values. The second one has the
corresponding range of values.

HTH


Hello Wigi.

Sorry, i tryed to do it now, but with no success. Could you somehow help
me with more detail?

example, in column A i have this numbers:
1,2100
1,2100
2,0000
1,4900
2,6400
1,5600
1,3500
1,8300
1,7600
2,3500
5,7400
1,9800
2,3300
5,9400
1,6500
so what formula/procedure should i do if i want to do this few ranges:
1,03-1,15
1,15-1,30
1,30-1,40
1,40-1,50


tnx in advance