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