Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
(→Calc functions listed by category: added Add-In date functions) |
(→Calc functions listed by category) |
||
Line 2: | Line 2: | ||
== Calc functions listed by category == | == Calc functions listed by category == | ||
− | + | These pages are a complete rewrite of the Function Help for Calc. Not all functions are included yet, but those here are described more precisely, completely and consistently than before. | |
+ | |||
+ | You may navigate directly to the functions from this page, or may select a function category, to find a one line description of each function, and some explanatory notes on the category. | ||
+ | |||
+ | The categories shown here are also used by the Function Wizard. | ||
+ | |||
'''[[Documentation/How_Tos/Calc: Database functions|Database functions]]''' | '''[[Documentation/How_Tos/Calc: Database functions|Database functions]]''' |
Revision as of 12:55, 17 February 2008
Calc functions listed by category
These pages are a complete rewrite of the Function Help for Calc. Not all functions are included yet, but those here are described more precisely, completely and consistently than before.
You may navigate directly to the functions from this page, or may select a function category, to find a one line description of each function, and some explanatory notes on the category.
The categories shown here are also used by 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.