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]
