I'm using excel 2003... I have a column (C7)with 16752 rows of #s 0 thru
24... I need to separate this column into ranges... i.e. <3; =3<5; =5<8,
etc... can i use an =if function to do this? I have tried
=if(C7=3<5,C7,"")... just returns a blank???
Thanks

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

If it's two conditions, you'll need to write them separately instead of
together, try:
=IF(AND(C7=3,C7<5),C7,"")

-Simon

"michael48" wrote:

I'm using excel 2003... I have a column (C7)with 16752 rows of #s 0 thru
24... I need to separate this column into ranges... i.e. <3; =3<5; =5<8,
etc... can i use an =if function to do this? I have tried
=if(C7=3<5,C7,"")... just returns a blank???
Thanks