Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
(→Calc functions listed by category: added Array finctions) |
(→Calc functions listed by category: added Add-In date functions) |
||
Line 10: | Line 10: | ||
'''[[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: 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: DAYSINMONTH function|DAYSINMONTH]] [[Documentation/How_Tos/Calc: DAYSINYEAR function|DAYSINYEAR]] [[Documentation/How_Tos/Calc: WEEKS function|WEEKS]] [[Documentation/How_Tos/Calc: WEEKSINYEAR function|WEEKSINYEAR]] [[Documentation/How_Tos/Calc: WEEKNUM function|WEEKNUM]] [[Documentation/How_Tos/Calc: WEEKNUM_ADD function|WEEKNUM_ADD]] [[Documentation/How_Tos/Calc: MONTHS function|MONTHS]] [[Documentation/How_Tos/Calc: YEARS function|YEARS]] [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ISLEAPYEAR]] [[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]]''' |
Revision as of 19:16, 14 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 DAYSINMONTH DAYSINYEAR WEEKS WEEKSINYEAR WEEKNUM WEEKNUM_ADD MONTHS YEARS ISLEAPYEAR 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.
- COS SIN TAN COT ACOS ACOT ASIN ATAN ATAN2 DEGREES RADIANS PI
- COSH SINH TANH COTH ACOSH ACOTH ASINH ATANH
- TRUNC ROUND ROUNDDOWN ROUNDUP CEILING FLOOR EVEN ODD MROUND INT QUOTIENT MOD
- EXP POWER LOG LN LOG10
- ABS COMBIN COMBINA CONVERT COUNTBLANK COUNTIF FACT FACTDOUBLE GCD GCD_ADD ISEVEN ISODD LCM LCM_ADD MULTINOMIAL PRODUCT RAND RANDBETWEEN SERIESSUM SIGN SQRT SQRTPI SUBTOTAL SUM SUMIF SUMSQ
- The Array functions operate on and return entire tables of data.
- FREQUENCY GROWTH LINEST LOGEST MDETERM MINVERSE MMULT MUNIT SUMPRODUCT SUMX2MY2 SUMX2PY2 SUMXMY2 TRANSPOSE TREND
- The Statistical functions allow statistical analysis of data.
- The 'Spreadsheet' functions find values in tables, or cell references.
- ADDRESS CHOOSE HLOOKUP INDEX INDIRECT LOOKUP MATCH OFFSET VLOOKUP
- AREAS COLUMN COLUMNS ERRORTYPE INFO ROW ROWS SHEET SHEETS
- DDE HYPERLINK STYLE
- The Text functions manipulate or return text.
- ARABIC BAHTTEXT BASE CHAR CLEAN CODE CONCATENATE DECIMAL DOLLAR EXACT FIND FIXED LEFT LEN
- The 'Add-in' functions are extra functions which may optionally be included in OpenOffice.org Calc.