Problem with getting numbers in some range values!?
 

In one colon i have a lot of numbers in range from 1,03 to 16,00
and i need to have it in other colon provided to show as text like:
1,03-1,15
1,15-1,30
1,30-1,40
1,40-1,50 etc. and i've done it with IF function and formula looks like
this:
=IF(K21,9;"1,90 - 2,0";IF(K21,8;"1,80 - 1,90";IF(K21,7;"1,70 -
1,80";IF(K21,6;"1,60 - 1,70";IF(K21,5;"1,50 - 1,60";IF(K21,4;"1,40 -
1,50";IF(K21,15;"1,15 - 1,30";IF(K21,01;"1,01 - 1,15";"1"))))))))

and it is working, but i need much more ranges - at least 20 more of
them, here when i'm trying to add one more excel doesn't allow me
because i have them 8 here already which is probably maximum!?

How to solve this to have this ranges arranged in more frequent number
ranges?

thanks in advance!

Problem with getting numbers in some range values!?
 

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

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Ivica TypeR" wrote:

In one colon i have a lot of numbers in range from 1,03 to 16,00
and i need to have it in other colon provided to show as text like:
1,03-1,15
1,15-1,30
1,30-1,40
1,40-1,50 etc. and i've done it with IF function and formula looks like
this:
=IF(K21,9;"1,90 - 2,0";IF(K21,8;"1,80 - 1,90";IF(K21,7;"1,70 -
1,80";IF(K21,6;"1,60 - 1,70";IF(K21,5;"1,50 - 1,60";IF(K21,4;"1,40 -
1,50";IF(K21,15;"1,15 - 1,30";IF(K21,01;"1,01 - 1,15";"1"))))))))

and it is working, but i need much more ranges - at least 20 more of
them, here when i'm trying to add one more excel doesn't allow me
because i have them 8 here already which is probably maximum!?

How to solve this to have this ranges arranged in more frequent number
ranges?

thanks in advance!

Problem with getting numbers in some range values!?
 

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