Now I got a bit confused.. Probably didnt put my question clearly enough :P
What I was planning to do was to use the Frequency function that got a syntax that is something like =Frequency(A2:A10,B2:B5) for column B Then use the cells of column A to define the intervals so that A2 would contain <1599 and A3 would be 1600-2499 for instance. What I have been unable to figure out is the syntax to write in those cells. On Fri, Jul 17, 2009 at 2:07 PM, Ashish P Aghera <[email protected]>wrote: > What I understand from your question is that you want 4 frequencies in > Column B depending on value in Column A. > Copy below formula to B1. and change "Freq1"2,3,4" to desired values. > > =IF(A1>6000;"Freq1";IF(A1>=2600;"Freq2";IF(A1>=2000;"Freq3";IF(A1>=0;"Fr > eq4";0)))) > > Ashish Aghera > > -----Original Message----- > From: Petter Wingren-Rasmussen [mailto:[email protected]] > Sent: Friday, July 17, 2009 3:26 PM > To: [email protected] > Subject: [users] Interval syntax when using Frequency in Calc > > Hi! > > My first post here and I'm fairly new to Open office. Couldnt find an > answer > to this simple question in the FAQ, built in help or mailing list > archives > so I'm posting here. > > What I want to do is to make a Frequency table where I can control the > intervals exactly. > The only thing I've figured out how to do is something like this: > > Values: Frequency: > 1500 345 > 3000 762 > 6000 342 > 9000 211 > > Where the frequencies as far as I understand it is calculated through > what > value is closest. I would like to control those calculated intervals > exactly > however, as in: > > Values: > 0-1999 > 2000-2599 > 2600-6000 > >6000 > > What syntax should I use for this to work? So far I've tried < and > > signs > and a:b and a;b without getting it to work.. > > All help and tips are appreciated :) > > Standard Disclaimer Conditions as per Tatachemicals Ltd Email Security > Policy apply > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
