Problem with getting numbers in some range values!?

  • Thread starter Thread starter Ivica TypeR
  • Start date Start date
I

Ivica TypeR

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(K2>1,9;"1,90 - 2,0";IF(K2>1,8;"1,80 - 1,90";IF(K2>1,7;"1,70 -
1,80";IF(K2>1,6;"1,60 - 1,70";IF(K2>1,5;"1,50 - 1,60";IF(K2>1,4;"1,40 -
1,50";IF(K2>1,15;"1,15 - 1,30";IF(K2>1,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!
 
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 said:
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
Click to expand...

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
Click to expand...
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
Click to expand...


tnx in advance
 
Back
Top