=if statement

[michael48]

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

[a7n9]

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

[SimonCC]

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