Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
(added the actual functions) |
(added maths functions) |
||
| Line 25: | Line 25: | ||
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | '''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | ||
:The Mathematical functions include trigonometric, hyperbolic, logarithmic and summation functions. | :The Mathematical functions include trigonometric, hyperbolic, logarithmic and summation functions. | ||
| − | + | :[[Documentation/How_Tos/Calc: COS function|COS]] [[Documentation/How_Tos/Calc: SIN function|SIN]] [[Documentation/How_Tos/Calc: TAN function|TAN]] [[Documentation/How_Tos/Calc: COT function|COT]] [[Documentation/How_Tos/Calc: ACOS function|ACOS]] [[Documentation/How_Tos/Calc: ACOT function|ACOT]] [[Documentation/How_Tos/Calc: ASIN function|ASIN]] [[Documentation/How_Tos/Calc: ATAN function|ATAN]] [[Documentation/How_Tos/Calc: ATAN2 function|ATAN2]] [[Documentation/How_Tos/Calc: DEGREES function|DEGREES]] [[Documentation/How_Tos/Calc: RADIANS function|RADIANS]] [[Documentation/How_Tos/Calc: PI function|PI]] | |
| + | :[[Documentation/How_Tos/Calc: COSH function|COSH]] [[Documentation/How_Tos/Calc: SINH function|SINH]] [[Documentation/How_Tos/Calc: TANH function|TANH]] [[Documentation/How_Tos/Calc: COTH function|COTH]] [[Documentation/How_Tos/Calc: ACOSH function|ACOSH]] [[Documentation/How_Tos/Calc: ACOTH function|ACOTH]] [[Documentation/How_Tos/Calc: ASINH function|ASINH]] [[Documentation/How_Tos/Calc: ATANH function|ATANH]] | ||
| + | : [[Documentation/How_Tos/Calc: TRUNC function|TRUNC]] [[Documentation/How_Tos/Calc: ROUND function|ROUND]] [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]] [[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]] [[Documentation/How_Tos/Calc: CEILING function|CEILING]] [[Documentation/How_Tos/Calc: FLOOR function|FLOOR]] [[Documentation/How_Tos/Calc: EVEN function|EVEN]] [[Documentation/How_Tos/Calc: ODD function|ODD]] [[Documentation/How_Tos/Calc: MROUND function|MROUND]] [[Documentation/How_Tos/Calc: INT function|INT]] [[Documentation/How_Tos/Calc: QUOTIENT function|QUOTIENT]] [[Documentation/How_Tos/Calc: MOD function|MOD]] | ||
| + | :[[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: 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. | ||
Revision as of 18:53, 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; 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.
