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]
>
>

Reply via email to