Thread: =if statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michael48 michael48 is offline
external usenet poster
 
Posts: 1
Default =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