OpenOffice Calc User Guide
Previous Page	Home	Next Page

Functions available in Calc

Table 9: Functions available in Calc

Function Category	Standard	Addins	Total
Mathematical	54	8	62
Financial	22	37	59
Statistical	77	0	77
Date and Time	17	13	30
Logical	6	0	6
Informational	16	2	18
Database	12	0	12
Array	14	0	14
Spreadsheet	20	0	20
Text	27	1	28
Total	265	61	326

Calc provides all of the commonly used functions found in modern spreadsheet applications. This appendix is offered to acquaint users with the available functions.Since many of Calc’s functions require veryspecific and carefully calculated input arguments, these descriptions should not be considered complete references for each function. More detailed explanations of the features and requirements of Calc’s functions can be found in the OpenOffice.org help system.

Over 250 standard functions are available in Calc, with many more available through its AddInfeature, which is briefly explained in the last section of this Appendix, “Add-in functionsâ€on page 61. The following tables list Calc’s functions organized in eleven functional categories. Throughout the lists below, any function marked with an asterisk (*) is only available if the Analysis AddIn is installed.

Note

Some of the descriptions in this appendix define limitations on the number of values or arguments that can be passed to the function. Specifically, functions that refer to the following arguments may lead to confusion. Number_1; number_2;... number_30 Number 1 to 30 a list of up to 30 numbers There is a significant difference between a list of numbers (or integers) and the number of arguments a function will accept. For, example the SUM function will only accept a maximum of 30 arguments. This limit does NOT mean that you can only sum 30 numbers, but that you can only pass 30 separate arguments to the function. Arguments are values separated by semi-colons, and can include ranges which often refer to multiple values. Therefore one argument can refer to several values, and a function that limits input to 30 arguments, may in fact accept more then 30 separate numerical values. This appendix attempts to clarify this situation by using the term arguments, rather than any of the aforementioned phrases. Unfortunately the OOo online help is somewhat vague regarding this matter.

Note

Functions whose names end with _ADD are provided for compatibility with Microsoft Excel functions. They return the same results as the corresponding functions in Excel (without the suffix), which though they may be correct, are not based on international standards. The _ADD functions are only available if the Analysis AddIn is installed.

OpenOffice Calc User Guide
Previous Page	Home	Next Page