data set. Data is the cell range of data. is the ranking of the value. Example =LARGE(A1:C50; ) gives the second largest value in the range A1:C50.
SMALL(Data; ) Returns the -th smallest value in a data set. Data is the cell range of data. is the rank of the value. Example =SMALL(A1:C50; ) gives the third smallest value in the range A1:C50.
AVERAGE(Number1; Number2; ... Number20) Returns the average of the arguments. Number1; Number2; ... Number20.
Example =AVERAGE(A1:A20) returns the average of set of values in the cell range A1:A20 . . – Working with the functions in Logical Category. IF (Test; TrueValue; FalseValue) Specifies a logical test to be performed.
Test is any value or expression that can be TRUE or FALSE. TrueValue (optional) is the value that is returned if the logical test is TRUE. FalseValue (optional) is the value that is returned if the logical test is FALSE. Example =IF(A1> ;”True”;"too small") If the value in A1 is higher than then the text “True” is returned in the current cell otherwise the text “too small” (without quotes) will be returned.
. . – Working with the functions in Date and Time Category OpenOffice Calc internally handles a date/time value as a numeric value. To change the number format to date or time, Select the cell containing the date or time, Click Format → Cell, select Numbers tab of the Format Cells Dialog Box, select the desired format.
Figure: . Number format . . – Working with the functions in Text Category CONCATENATE("Text1"; "Text2";"Text3"; ...) Combines several text strings into one string.
Text1; Text2; Text3; ... are to text passages which are to be concatenated together into one string. Example =CONCATENATE("Good ";"Morning ";"Mr. ";"Ramki") returns Good Morning Mr.
Ramki DECIMAL("Text"; Radix) Converts a text string with characters from a number system to a positive integer in the base radix given. Text is the text string to be converted. To differentiate between a hexadecimal number, such as A1 and a cell address A1, you must place the text in quotation marks, for example, "A1" or "FACE". Radix