Functions Available in Calc

Apache OpenOffice 4.1 Calc Guide

Appendix B — Description of Functions

< Previous Section

Next Section >

• Functions Available in Calc
  • Terminology: Numbers and Arguments
• Mathematical Functions
• Financial Analysis Functions
  • A Note About Dates
  • A Note About Interest Rates
• Statistical Analysis Functions
• Date and Time Functions
• Logical Functions
• Informational Functions
• Database Functions
• Array Functions
• Spreadsheet Functions
• Text Functions
• Converting Decimal, Binary, Octal, Hexadecimal
• Complex Number Functions

< Previous Page

Next Page >

Functions Available in Calc

Calc provides all the commonly used functions found in modern spreadsheet applications. Since many of Calc’s functions require very specific and carefully calculated input arguments, the descriptions in this appendix should not be considered complete references for each function. Refer to the application Help or the OpenOffice wiki for details and examples of all functions. On the wiki, start with https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category

Over 300 standard functions are available in Calc. More can be added through extensions to Calc (see Chapter 14). The following tables list Calc’s functions organized into eleven categories.

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.