Range from to Low Upper
1 0 50 5% 95%
2 51 100 10% 90%
3 101 999999 20% 70%


If 0 =< 50 then 1
If = 51 < = 100 then 2
if 100 then 3


I struggling wit a if function and this is what I want, assistanc
appreciated


thanks

Thie

--
Thie
-----------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...fo&userid=2747
View this thread: http://www.excelforum.com/showthread.php?threadid=52814