=if statement

M

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
 
A

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
 
S

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
 
Top