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!

See

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


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