=IF(A1<=0,0,IF(A1<=50,1,IF(A1<=100,2,3)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Thiem" wrote in
message ...

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, assistance
appreciated


thanks

Thiem


--
Thiem
------------------------------------------------------------------------
Thiem's Profile:
http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=528147