Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
(Initial content) |
|||
Line 36: | Line 36: | ||
'''[[Documentation/How_Tos/Documentation/How_Tos/Calc: Add-in functions|Add-in functions]]''' | '''[[Documentation/How_Tos/Documentation/How_Tos/Calc: Add-in functions|Add-in functions]]''' | ||
:The 'Add-in' functions are extra functions which may optionally be included in OpenOffice.org Calc. | :The 'Add-in' functions are extra functions which may optionally be included in OpenOffice.org Calc. | ||
+ | |||
+ | |||
+ | [[Category:Documentation]] | ||
+ | [[Category:Calc]] |
Revision as of 11:04, 6 December 2007
Calc functions listed by category
OpenOffice.org Calc functions are divided into categories, both here and also in the Function Wizard.
- The Database functions are used to extract information from Calc data tables, where data is organised in rows.
- The Date & Time functions are used to manipulate dates and times.
- The Financial functions provide common business calculations.
- The Information functions return information about cells, such as whether they contain text or a formula, etc.
- The Logical functions include boolean logic AND, OR, NOT functions, and functions such as IF which test a logical result.
- The Mathematical functions include trigonometric, hyperbolic, logarithmic and summation functions.
- The Array functions operate on and return entire tables of data.
- The Statistical functions allow statistical analysis of data.
- The 'Spreadsheet' functions find values in tables, or cell references; they include LOOKUP, SEARCH, ADDRESS
- The Text functions manipulate or return text.
- The 'Add-in' functions are extra functions which may optionally be included in OpenOffice.org Calc.