Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
(added the actual functions) |
|||
Line 5: | Line 5: | ||
'''[[Documentation/How_Tos/Calc: Database functions|Database functions]]''' | '''[[Documentation/How_Tos/Calc: Database functions|Database functions]]''' | ||
− | :The Database functions are used to extract information from Calc data tables, where data is organised in rows. | + | :The Database functions are used to extract information from Calc data tables, where data is organised in rows. |
+ | :[[Documentation/How_Tos/Calc: DCOUNT function|DCOUNT]] [[Documentation/How_Tos/Calc: DCOUNTA function|DCOUNTA]] [[Documentation/How_Tos/Calc: DGET function|DGET]] [[Documentation/How_Tos/Calc: DMAX function|DMAX]] [[Documentation/How_Tos/Calc: DMIN function|DMIN]] [[Documentation/How_Tos/Calc: DAVERAGE function|DAVERAGE]] [[Documentation/How_Tos/Calc: DPRODUCT function|DPRODUCT]] [[Documentation/How_Tos/Calc: DSTDEV function|DSTDEV]] [[Documentation/How_Tos/Calc: DSTDEVP function|DSTDEVP]] [[Documentation/How_Tos/Calc: DSUM function|DSUM]] [[Documentation/How_Tos/Calc: DVAR function|DVAR]] [[Documentation/How_Tos/Calc: DVARP function|DVARP]] | ||
'''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]''' | '''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]''' | ||
− | :The Date & Time functions are used to manipulate dates and times. | + | :The Date & Time functions are used to manipulate dates and times. |
+ | :[[Documentation/How_Tos/Calc: TODAY function|TODAY]] [[Documentation/How_Tos/Calc: NOW function|NOW]] [[Documentation/How_Tos/Calc: YEAR function|YEAR]] [[Documentation/How_Tos/Calc: MONTH function|MONTH]] [[Documentation/How_Tos/Calc: DAY function|DAY]] [[Documentation/How_Tos/Calc: WEEKDAY function|WEEKDAY]] [[Documentation/How_Tos/Calc: HOUR function|HOUR]] [[Documentation/How_Tos/Calc: MINUTE function|MINUTE]] [[Documentation/How_Tos/Calc: SECOND function|SECOND]] [[Documentation/How_Tos/Calc: DATE function|DATE]] [[Documentation/How_Tos/Calc: DATEVALUE function|DATEVALUE]] [[Documentation/How_Tos/Calc: TIME function|TIME]] [[Documentation/How_Tos/Calc: TIMEVALUE function|TIMEVALUE]] [[Documentation/How_Tos/Calc: EOMONTH function|EOMONTH]] [[Documentation/How_Tos/Calc: EDATE function|EDATE]] [[Documentation/How_Tos/Calc: WORKDAY function|WORKDAY]] [[Documentation/How_Tos/Calc: NETWORKDAYS function|NETWORKDAYS]] [[Documentation/How_Tos/Calc: DAYS function|DAYS]] [[Documentation/How_Tos/Calc: DAYS360 function|DAYS360]] [[Documentation/How_Tos/Calc: WEEKNUM function|WEEKNUM]] [[Documentation/How_Tos/Calc: WEEKNUM_ADD function|WEEKNUM_ADD]] [[Documentation/How_Tos/Calc: EASTERSUNDAY function|EASTERSUNDAY]] [[Documentation/How_Tos/Calc: YEARFRAC function|YEARFRAC]] | ||
'''[[Documentation/How_Tos/Calc: Financial functions|Financial functions]]''' | '''[[Documentation/How_Tos/Calc: Financial functions|Financial functions]]''' | ||
Line 15: | Line 17: | ||
'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''' | '''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''' | ||
:The Information functions return information about cells, such as whether they contain text or a formula, etc. | :The Information functions return information about cells, such as whether they contain text or a formula, etc. | ||
+ | :[[Documentation/How_Tos/Calc: CELL function|CELL]] [[Documentation/How_Tos/Calc: CURRENT function|CURRENT]] [[Documentation/How_Tos/Calc: FORMULA function|FORMULA]] [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]] [[Documentation/How_Tos/Calc: ISERR function|ISERR]] [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]] [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]] [[Documentation/How_Tos/Calc: ISEVEN_ADD function|ISEVEN_ADD]] [[Documentation/How_Tos/Calc: ISFORMULA function|ISFORMULA]] [[Documentation/How_Tos/Calc: ISLOGICAL function|ISLOGICAL]] [[Documentation/How_Tos/Calc: ISNA function|ISNA]] [[Documentation/How_Tos/Calc: ISNONTEXT function|ISNONTEXT]] [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]] [[Documentation/How_Tos/Calc: ISODD function|ISODD]] [[Documentation/How_Tos/Calc: ISODD_ADD function|ISODD_ADD]] [[Documentation/How_Tos/Calc: ISREF function|ISREF]] [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]] [[Documentation/How_Tos/Calc: N function|N]] [[Documentation/How_Tos/Calc: NA function|NA]] [[Documentation/How_Tos/Calc: TYPE function|TYPE]] | ||
'''[[Documentation/How_Tos/Calc: Logical functions|Logical functions]]''' | '''[[Documentation/How_Tos/Calc: Logical functions|Logical functions]]''' | ||
:The Logical functions include boolean logic '''AND''', '''OR''', '''NOT''' functions, and functions such as '''IF''' which test a logical result. | :The Logical functions include boolean logic '''AND''', '''OR''', '''NOT''' functions, and functions such as '''IF''' which test a logical result. | ||
+ | :[[Documentation/How_Tos/Calc: AND function|AND]] [[Documentation/How_Tos/Calc: FALSE function|FALSE]] [[Documentation/How_Tos/Calc: IF function|IF]] [[Documentation/How_Tos/Calc: NOT function|NOT]] [[Documentation/How_Tos/Calc: OR function|OR]] [[Documentation/How_Tos/Calc: TRUE function|TRUE]] | ||
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | '''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' |
Revision as of 17:55, 12 February 2008
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.
- DCOUNT DCOUNTA DGET DMAX DMIN DAVERAGE DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP
- The Date & Time functions are used to manipulate dates and times.
- TODAY NOW YEAR MONTH DAY WEEKDAY HOUR MINUTE SECOND DATE DATEVALUE TIME TIMEVALUE EOMONTH EDATE WORKDAY NETWORKDAYS DAYS DAYS360 WEEKNUM WEEKNUM_ADD EASTERSUNDAY YEARFRAC
- The Financial functions provide common business calculations.
- The Information functions return information about cells, such as whether they contain text or a formula, etc.
- CELL CURRENT FORMULA ISBLANK ISERR ISERROR ISEVEN ISEVEN_ADD ISFORMULA ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISODD_ADD ISREF ISTEXT N NA TYPE
- The Logical functions include boolean logic AND, OR, NOT functions, and functions such as IF which test a logical result.
- AND FALSE IF NOT OR TRUE
- 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.