![]() |
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!?
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