Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
(added maths functions) |
(added 'Spreadsheet' functions) |
||
Line 30: | Line 30: | ||
:[[Documentation/How_Tos/Calc: EXP function|EXP]] [[Documentation/How_Tos/Calc: POWER function|POWER]] [[Documentation/How_Tos/Calc: LOG function|LOG]] [[Documentation/How_Tos/Calc: LN function|LN]] [[Documentation/How_Tos/Calc: LOG10 function|LOG10]] | :[[Documentation/How_Tos/Calc: EXP function|EXP]] [[Documentation/How_Tos/Calc: POWER function|POWER]] [[Documentation/How_Tos/Calc: LOG function|LOG]] [[Documentation/How_Tos/Calc: LN function|LN]] [[Documentation/How_Tos/Calc: LOG10 function|LOG10]] | ||
:[[Documentation/How_Tos/Calc: ABS function|ABS]] [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]] [[Documentation/How_Tos/Calc: COMBINA function|COMBINA]] [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]] [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]] [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]] [[Documentation/How_Tos/Calc: FACT function|FACT]] [[Documentation/How_Tos/Calc: FACTDOUBLE function|FACTDOUBLE]] [[Documentation/How_Tos/Calc: GCD function|GCD]] [[Documentation/How_Tos/Calc: GCD_ADD function|GCD_ADD]] [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]] [[Documentation/How_Tos/Calc: ISODD function|ISODD]] [[Documentation/How_Tos/Calc: LCM function|LCM]] [[Documentation/How_Tos/Calc: LCM_ADD function|LCM_ADD]] [[Documentation/How_Tos/Calc: MULTINOMIAL function|MULTINOMIAL]] [[Documentation/How_Tos/Calc: PRODUCT function|PRODUCT]] [[Documentation/How_Tos/Calc: RAND function|RAND]] [[Documentation/How_Tos/Calc: RANDBETWEEN function|RANDBETWEEN]] [[Documentation/How_Tos/Calc: SERIESSUM function|SERIESSUM]] [[Documentation/How_Tos/Calc: SIGN function|SIGN]] [[Documentation/How_Tos/Calc: SQRT function|SQRT]] [[Documentation/How_Tos/Calc: SQRTPI function|SQRTPI]] [[Documentation/How_Tos/Calc: SUBTOTAL function|SUBTOTAL]] [[Documentation/How_Tos/Calc: SUM function|SUM]] [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]] [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]] | :[[Documentation/How_Tos/Calc: ABS function|ABS]] [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]] [[Documentation/How_Tos/Calc: COMBINA function|COMBINA]] [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]] [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]] [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]] [[Documentation/How_Tos/Calc: FACT function|FACT]] [[Documentation/How_Tos/Calc: FACTDOUBLE function|FACTDOUBLE]] [[Documentation/How_Tos/Calc: GCD function|GCD]] [[Documentation/How_Tos/Calc: GCD_ADD function|GCD_ADD]] [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]] [[Documentation/How_Tos/Calc: ISODD function|ISODD]] [[Documentation/How_Tos/Calc: LCM function|LCM]] [[Documentation/How_Tos/Calc: LCM_ADD function|LCM_ADD]] [[Documentation/How_Tos/Calc: MULTINOMIAL function|MULTINOMIAL]] [[Documentation/How_Tos/Calc: PRODUCT function|PRODUCT]] [[Documentation/How_Tos/Calc: RAND function|RAND]] [[Documentation/How_Tos/Calc: RANDBETWEEN function|RANDBETWEEN]] [[Documentation/How_Tos/Calc: SERIESSUM function|SERIESSUM]] [[Documentation/How_Tos/Calc: SIGN function|SIGN]] [[Documentation/How_Tos/Calc: SQRT function|SQRT]] [[Documentation/How_Tos/Calc: SQRTPI function|SQRTPI]] [[Documentation/How_Tos/Calc: SUBTOTAL function|SUBTOTAL]] [[Documentation/How_Tos/Calc: SUM function|SUM]] [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]] [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]] | ||
+ | |||
'''[[Documentation/How_Tos/Calc: Array functions|Array functions]]''' | '''[[Documentation/How_Tos/Calc: Array functions|Array functions]]''' | ||
:The Array functions operate on and return entire tables of data. | :The Array functions operate on and return entire tables of data. | ||
Line 37: | Line 38: | ||
'''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]''' | '''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]''' | ||
− | :The 'Spreadsheet' functions find values in tables, or cell references | + | :The 'Spreadsheet' functions find values in tables, or cell references. |
+ | :[[Documentation/How_Tos/Calc: ADDRESS function|ADDRESS]] [[Documentation/How_Tos/Calc: CHOOSE function|CHOOSE]] [[Documentation/How_Tos/Calc: HLOOKUP function|HLOOKUP]] [[Documentation/How_Tos/Calc: INDEX function|INDEX]] [[Documentation/How_Tos/Calc: INDIRECT function|INDIRECT]] [[Documentation/How_Tos/Calc: LOOKUP function|LOOKUP]] [[Documentation/How_Tos/Calc: MATCH function|MATCH]] [[Documentation/How_Tos/Calc: OFFSET function|OFFSET]] [[Documentation/How_Tos/Calc: VLOOKUP function|VLOOKUP]] | ||
+ | :[[Documentation/How_Tos/Calc: AREAS function|AREAS]] [[Documentation/How_Tos/Calc: COLUMN function|COLUMN]] [[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]] [[Documentation/How_Tos/Calc: ERRORTYPE function|ERRORTYPE]] [[Documentation/How_Tos/Calc: INFO function|INFO]] [[Documentation/How_Tos/Calc: ROW function|ROW]] [[Documentation/How_Tos/Calc: ROWS function|ROWS]] [[Documentation/How_Tos/Calc: SHEET function|SHEET]] [[Documentation/How_Tos/Calc: SHEETS function|SHEETS]] | ||
+ | :[[Documentation/How_Tos/Calc: DDE function|DDE]] [[Documentation/How_Tos/Calc: HYPERLINK function|HYPERLINK]] [[Documentation/How_Tos/Calc: STYLE function|STYLE]] | ||
'''[[Documentation/How_Tos/Calc: Text functions|Text functions]]''' | '''[[Documentation/How_Tos/Calc: Text functions|Text functions]]''' |
Revision as of 19:01, 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.
- 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.
- 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.
- The 'Add-in' functions are extra functions which may optionally be included in OpenOffice.org Calc.