You'd be better off using VLOOKUP function. Set up a table like this:
A B
0 <3
1 <3
2 <3
3 =3<5
4 =3<5
5 =5<8
6 =5<8
7 =5<8
then use VLOOKUP like this: =VLOOKUP(3,A1:B8,2,0) . Check help for more
info on VLOOKUP
--
a7n9
------------------------------------------------------------------------
a7n9's Profile:
http://www.excelforum.com/member.php...o&userid=32149
View this thread:
http://www.excelforum.com/showthread...hreadid=562923