ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with getting numbers in some range values!? (https://www.excelbanter.com/excel-programming/392983-problem-getting-numbers-some-range-values.html)

Ivica TypeR

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!

Wigi

Problem with getting numbers in some range values!?
 
See

http://www.microsoft.com/communities...=en-us&m=1&p=1


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


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com