Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=if statement
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=if statement
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=if statement
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |