Difference between revisions of "Template:Calc functions"

From Apache OpenOffice Wiki
Jump to: navigation, search
(+cat)
 
(28 intermediate revisions by 7 users not shown)
Line 1: Line 1:
__NOTOC__
 
{{DISPLAYTITLE:Calc Functions listed by category}}
 
 
== Calc functions listed by category ==
 
These pages are a complete rewrite of the Function Help for Calc, with links to other relevant topics. The aim is to have more detail and support than the Help pages for other major spreadsheets.
 
 
You may
 
*navigate directly to the functions from this page, or
 
*select a '''function category''', to find a one line description of each function and explanatory notes on the category, or
 
*see a list of '''[[Documentation/How_Tos/Calc: Functions listed alphabetically|functions in alphabetic order]]'''.
 
 
 
'''[[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.  
:<b>&middot; </b>[[Documentation/How_Tos/Calc: FREQUENCY function|FREQUENCY]], [[Documentation/How_Tos/Calc: GROWTH function|GROWTH]], [[Documentation/How_Tos/Calc: LINEST function|LINEST]], [[Documentation/How_Tos/Calc: LOGEST function|LOGEST]], [[Documentation/How_Tos/Calc: MDETERM function|MDETERM]], [[Documentation/How_Tos/Calc: MINVERSE function|MINVERSE]], [[Documentation/How_Tos/Calc: MMULT function|MMULT]], [[Documentation/How_Tos/Calc: MUNIT function|MUNIT]], [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]], [[Documentation/How_Tos/Calc: SUMX2MY2 function|SUMX2MY2]], [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]], [[Documentation/How_Tos/Calc: SUMXMY2 function|SUMXMY2]], [[Documentation/How_Tos/Calc: TRANSPOSE function|TRANSPOSE]], [[Documentation/How_Tos/Calc: TREND function|TREND]]  
+
:<b>&middot; </b>[[Documentation/How_Tos/Calc: FREQUENCY function|FREQUENCY]], [[Documentation/How_Tos/Calc: GROWTH function|GROWTH]], [[Documentation/How_Tos/Calc: LINEST function|LINEST]], [[Documentation/How_Tos/Calc: LOGEST function|LOGEST]], [[Documentation/How_Tos/Calc: MDETERM function|MDETERM]], [[Documentation/How_Tos/Calc: MINVERSE function|MINVERSE]], [[Documentation/How_Tos/Calc: MMULT function|MMULT]], [[Documentation/How_Tos/Calc: MUNIT function|MUNIT]], [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]], [[Documentation/How_Tos/Calc: SUMX2MY2 function|SUMX2MY2]], [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]], [[Documentation/How_Tos/Calc: SUMXMY2 function|SUMXMY2]], [[Documentation/How_Tos/Calc: TRANSPOSE function|TRANSPOSE]], [[Documentation/How_Tos/Calc: TREND function|TREND]]
  
 
'''[[Documentation/How_Tos/Calc: Complex Number functions|Complex Number functions]]'''
 
'''[[Documentation/How_Tos/Calc: Complex Number functions|Complex Number functions]]'''
 
:The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.
 
:The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.
:<b>&middot; </b>[[Documentation/How_Tos/Calc: COMPLEX function|COMPLEX]], [[Documentation/How_Tos/Calc: IMABS function|IMABS]], [[Documentation/How_Tos/Calc: IMAGINARY function|IMAGINARY]], [[Documentation/How_Tos/Calc: IMPOWER function|IMPOWER]], [[Documentation/How_Tos/Calc: IMARGUMENT function|IMARGUMENT]], [[Documentation/How_Tos/Calc: IMCOS function|IMCOS]], [[Documentation/How_Tos/Calc: IMDIV function|IMDIV]], [[Documentation/How_Tos/Calc: IMEXP function|IMEXP]], [[Documentation/How_Tos/Calc: IMCONJUGATE function|IMCONJUGATE]], [[Documentation/How_Tos/Calc: IMLN function|IMLN]], [[Documentation/How_Tos/Calc: IMLOG10 function|IMLOG10]], [[Documentation/How_Tos/Calc: IMLOG2 function|IMLOG2]], [[Documentation/How_Tos/Calc: IMPRODUCT function|IMPRODUCT]], [[Documentation/How_Tos/Calc: IMREAL function|IMREAL]], [[Documentation/How_Tos/Calc: IMSIN function|IMSIN]], [[Documentation/How_Tos/Calc: IMSUB function|IMSUB]], [[Documentation/How_Tos/Calc: IMSUM function|IMSUM]], [[Documentation/How_Tos/Calc: IMSQRT function|IMSQRT]]
+
:<b>&middot; </b>[[Documentation/How_Tos/Calc: COMPLEX function|COMPLEX]], [[Documentation/How_Tos/Calc: IMABS function|IMABS]], [[Documentation/How_Tos/Calc: IMAGINARY function|IMAGINARY]], [[Documentation/How_Tos/Calc: IMPOWER function|IMPOWER]], [[Documentation/How_Tos/Calc: IMARGUMENT function|IMARGUMENT]], [[Documentation/How_Tos/Calc: IMCOS function|IMCOS]], [[Documentation/How_Tos/Calc: IMCOSH function|IMCOSH]], [[Documentation/How_Tos/Calc: IMCOT function|IMCOT]], [[Documentation/How_Tos/Calc: IMCSC function|IMCSC]], [[Documentation/How_Tos/Calc: IMCSCH function|IMCSCH]], [[Documentation/How_Tos/Calc: IMDIV function|IMDIV]], [[Documentation/How_Tos/Calc: IMEXP function|IMEXP]], [[Documentation/How_Tos/Calc: IMCONJUGATE function|IMCONJUGATE]], [[Documentation/How_Tos/Calc: IMLN function|IMLN]], [[Documentation/How_Tos/Calc: IMLOG10 function|IMLOG10]], [[Documentation/How_Tos/Calc: IMLOG2 function|IMLOG2]], [[Documentation/How_Tos/Calc: IMPRODUCT function|IMPRODUCT]], [[Documentation/How_Tos/Calc: IMREAL function|IMREAL]], [[Documentation/How_Tos/Calc: IMSEC function|IMSEC]], [[Documentation/How_Tos/Calc: IMSECH function|IMSECH]], [[Documentation/How_Tos/Calc: IMSIN function|IMSIN]], [[Documentation/How_Tos/Calc: IMSINH function|IMSINH]], [[Documentation/How_Tos/Calc: IMSQRT function|IMSQRT]], [[Documentation/How_Tos/Calc: IMSUB function|IMSUB]], [[Documentation/How_Tos/Calc: IMSUM function|IMSUM]], [[Documentation/How_Tos/Calc: IMTAN function|IMTAN]]
 +
 
  
 
'''[[Documentation/How_Tos/Calc: Database functions|Database functions]]'''
 
'''[[Documentation/How_Tos/Calc: Database functions|Database functions]]'''
Line 40: Line 30:
 
'''[[Documentation/How_Tos/Calc: Logical functions|Logical functions]]'''
 
'''[[Documentation/How_Tos/Calc: Logical functions|Logical functions]]'''
 
:The Logical functions allow boolean logic decisions.  
 
:The Logical functions allow boolean logic decisions.  
:<b>&middot; </b>[[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]]
+
:<b>&middot; </b>[[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: XOR function|XOR]]
  
 
'''[[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.  
 
:<b>&middot; </b>[[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]]  
 
:<b>&middot; </b>[[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]]  
:<b>&middot; </b>[[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]]  
+
:<b>&middot; </b>[[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: CSC function|CSC]], [[Documentation/How_Tos/Calc: CSCH function|CSCH]],  [[Documentation/How_Tos/Calc: SEC function|SEC]], [[Documentation/How_Tos/Calc: SECH function|SECH]]
 
:<b>&middot; </b>[[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]]  
 
:<b>&middot; </b>[[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]]  
 
:<b>&middot; </b>[[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]]  
 
:<b>&middot; </b>[[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]]  
Line 66: Line 56:
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]], [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]], [[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]], [[Documentation/How_Tos/Calc: COUNT function|COUNT]], [[Documentation/How_Tos/Calc: COUNTA function|COUNTA]], [[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]], [[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]], [[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]], [[Documentation/How_Tos/Calc: MODE function|MODE]], [[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]]
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]], [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]], [[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]], [[Documentation/How_Tos/Calc: COUNT function|COUNT]], [[Documentation/How_Tos/Calc: COUNTA function|COUNTA]], [[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]], [[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]], [[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]], [[Documentation/How_Tos/Calc: MODE function|MODE]], [[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]]
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]], [[Documentation/How_Tos/Calc: KURT function|KURT]], [[Documentation/How_Tos/Calc: SKEW function|SKEW]], [[Documentation/How_Tos/Calc: STDEV function|STDEV]], [[Documentation/How_Tos/Calc: STDEVA function|STDEVA]], [[Documentation/How_Tos/Calc: STDEVP function|STDEVP]], [[Documentation/How_Tos/Calc: STDEVPA function|STDEVPA]], [[Documentation/How_Tos/Calc: VAR function|VAR]], [[Documentation/How_Tos/Calc: VARA function|VARA]], [[Documentation/How_Tos/Calc: VARP function|VARP]], [[Documentation/How_Tos/Calc: VARPA function|VARPA]]
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]], [[Documentation/How_Tos/Calc: KURT function|KURT]], [[Documentation/How_Tos/Calc: SKEW function|SKEW]], [[Documentation/How_Tos/Calc: STDEV function|STDEV]], [[Documentation/How_Tos/Calc: STDEVA function|STDEVA]], [[Documentation/How_Tos/Calc: STDEVP function|STDEVP]], [[Documentation/How_Tos/Calc: STDEVPA function|STDEVPA]], [[Documentation/How_Tos/Calc: VAR function|VAR]], [[Documentation/How_Tos/Calc: VARA function|VARA]], [[Documentation/How_Tos/Calc: VARP function|VARP]], [[Documentation/How_Tos/Calc: VARPA function|VARPA]]
:<b>&middot; </b>[[Documentation/How_Tos/Calc: B function|B]], [[Documentation/How_Tos/Calc: BETADIST function|BETADIST]], [[Documentation/How_Tos/Calc: BETAINV function|BETAINV]], [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]], [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]], [[Documentation/How_Tos/Calc: CHISQDIST function|CHISQDIST]], [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]], [[Documentation/How_Tos/Calc: CHITEST function|CHITEST]], [[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]], [[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]], [[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]], [[Documentation/How_Tos/Calc: FINV function|FINV]], [[Documentation/How_Tos/Calc: FISHER function|FISHER]], [[Documentation/How_Tos/Calc: FISHERINV function|FISHERINV]], [[Documentation/How_Tos/Calc: FDIST function|FDIST]], [[Documentation/How_Tos/Calc: FTEST function|FTEST]], [[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]], [[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]], [[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]], [[Documentation/How_Tos/Calc: GAUSS function|GAUSS]], [[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]], [[Documentation/How_Tos/Calc: LOGINV function|LOGINV]], [[Documentation/How_Tos/Calc: LOGNORMDIST function|LOGNORMDIST]], [[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]], [[Documentation/How_Tos/Calc: NORMINV function|NORMINV]], [[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]], [[Documentation/How_Tos/Calc: NORMSINV function|NORMSINV]], [[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]], [[Documentation/How_Tos/Calc: PERMUT function|PERMUT]], [[Documentation/How_Tos/Calc: PERMUTATIONA function|PERMUTATIONA]], [[Documentation/How_Tos/Calc: PHI function|PHI]], [[Documentation/How_Tos/Calc: POISSON function|POISSON]], [[Documentation/How_Tos/Calc: PROB function|PROB]], [[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]], [[Documentation/How_Tos/Calc: TDIST function|TDIST]], [[Documentation/How_Tos/Calc: TINV function|TINV]], [[Documentation/How_Tos/Calc: TTEST function|TTEST]], [[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]], [[Documentation/How_Tos/Calc: ZTEST function|ZTEST]]
+
:<b>&middot; </b>[[Documentation/How_Tos/Calc: B function|B]], [[Documentation/How_Tos/Calc: BETADIST function|BETADIST]], [[Documentation/How_Tos/Calc: BETAINV function|BETAINV]], [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]], [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]], [[Documentation/How_Tos/Calc: CHISQDIST function|CHISQDIST]], [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]], [[Documentation/How_Tos/Calc: CHISQINV function|CHISQINV]], [[Documentation/How_Tos/Calc: CHITEST function|CHITEST]], [[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]], [[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]], [[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]], [[Documentation/How_Tos/Calc: FINV function|FINV]], [[Documentation/How_Tos/Calc: FISHER function|FISHER]], [[Documentation/How_Tos/Calc: FISHERINV function|FISHERINV]], [[Documentation/How_Tos/Calc: FDIST function|FDIST]], [[Documentation/How_Tos/Calc: FTEST function|FTEST]], [[Documentation/How_Tos/Calc: GAMMA function|GAMMA]], [[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]], [[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]], [[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]], [[Documentation/How_Tos/Calc: GAUSS function|GAUSS]], [[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]], [[Documentation/How_Tos/Calc: LOGINV function|LOGINV]], [[Documentation/How_Tos/Calc: LOGNORMDIST function|LOGNORMDIST]], [[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]], [[Documentation/How_Tos/Calc: NORMINV function|NORMINV]], [[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]], [[Documentation/How_Tos/Calc: NORMSINV function|NORMSINV]], [[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]], [[Documentation/How_Tos/Calc: PERMUT function|PERMUT]], [[Documentation/How_Tos/Calc: PERMUTATIONA function|PERMUTATIONA]], [[Documentation/How_Tos/Calc: PHI function|PHI]], [[Documentation/How_Tos/Calc: POISSON function|POISSON]], [[Documentation/How_Tos/Calc: PROB function|PROB]], [[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]], [[Documentation/How_Tos/Calc: TDIST function|TDIST]], [[Documentation/How_Tos/Calc: TINV function|TINV]], [[Documentation/How_Tos/Calc: TTEST function|TTEST]], [[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]], [[Documentation/How_Tos/Calc: ZTEST function|ZTEST]]
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: CORREL function|CORREL]], [[Documentation/How_Tos/Calc: COVAR function|COVAR]], [[Documentation/How_Tos/Calc: FORECAST function|FORECAST]], [[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]], [[Documentation/How_Tos/Calc: PEARSON function|PEARSON]], [[Documentation/How_Tos/Calc: RSQ function|RSQ]], [[Documentation/How_Tos/Calc: SLOPE function|SLOPE]], [[Documentation/How_Tos/Calc: STEYX function|STEYX]]
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: CORREL function|CORREL]], [[Documentation/How_Tos/Calc: COVAR function|COVAR]], [[Documentation/How_Tos/Calc: FORECAST function|FORECAST]], [[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]], [[Documentation/How_Tos/Calc: PEARSON function|PEARSON]], [[Documentation/How_Tos/Calc: RSQ function|RSQ]], [[Documentation/How_Tos/Calc: SLOPE function|SLOPE]], [[Documentation/How_Tos/Calc: STEYX function|STEYX]]
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: LARGE function|LARGE]], [[Documentation/How_Tos/Calc: MAX function|MAX]], [[Documentation/How_Tos/Calc: MAXA function|MAXA]], [[Documentation/How_Tos/Calc: MIN function|MIN]], [[Documentation/How_Tos/Calc: MINA function|MINA]], [[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]], [[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]], [[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]], [[Documentation/How_Tos/Calc: RANK function|RANK]], [[Documentation/How_Tos/Calc: SMALL function|SMALL]]
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: LARGE function|LARGE]], [[Documentation/How_Tos/Calc: MAX function|MAX]], [[Documentation/How_Tos/Calc: MAXA function|MAXA]], [[Documentation/How_Tos/Calc: MIN function|MIN]], [[Documentation/How_Tos/Calc: MINA function|MINA]], [[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]], [[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]], [[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]], [[Documentation/How_Tos/Calc: RANK function|RANK]], [[Documentation/How_Tos/Calc: SMALL function|SMALL]]
Line 73: Line 63:
 
:The Text functions manipulate or return text.  
 
:The Text functions manipulate or return text.  
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: BASE function|BASE]], [[Documentation/How_Tos/Calc: CHAR function|CHAR]], [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]], [[Documentation/How_Tos/Calc: CODE function|CODE]], [[Documentation/How_Tos/Calc: CONCATENATE function|CONCATENATE]], [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: EXACT function|EXACT]], [[Documentation/How_Tos/Calc: FIND function|FIND]], [[Documentation/How_Tos/Calc: FIXED function|FIXED]], [[Documentation/How_Tos/Calc: LEFT function|LEFT]], [[Documentation/How_Tos/Calc: LEN function|LEN]], [[Documentation/How_Tos/Calc: LOWER function|LOWER]], [[Documentation/How_Tos/Calc: MID function|MID]], [[Documentation/How_Tos/Calc: PROPER function|PROPER]], [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]], [[Documentation/How_Tos/Calc: REPT function|REPT]], [[Documentation/How_Tos/Calc: RIGHT function|RIGHT]], [[Documentation/How_Tos/Calc: SEARCH function|SEARCH]], [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]], [[Documentation/How_Tos/Calc: T function|T]], [[Documentation/How_Tos/Calc: TEXT function|TEXT]], [[Documentation/How_Tos/Calc: TRIM function|TRIM]], [[Documentation/How_Tos/Calc: UPPER function|UPPER]], [[Documentation/How_Tos/Calc: VALUE function|VALUE]]
 
:<b>&middot; </b>[[Documentation/How_Tos/Calc: BASE function|BASE]], [[Documentation/How_Tos/Calc: CHAR function|CHAR]], [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]], [[Documentation/How_Tos/Calc: CODE function|CODE]], [[Documentation/How_Tos/Calc: CONCATENATE function|CONCATENATE]], [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: EXACT function|EXACT]], [[Documentation/How_Tos/Calc: FIND function|FIND]], [[Documentation/How_Tos/Calc: FIXED function|FIXED]], [[Documentation/How_Tos/Calc: LEFT function|LEFT]], [[Documentation/How_Tos/Calc: LEN function|LEN]], [[Documentation/How_Tos/Calc: LOWER function|LOWER]], [[Documentation/How_Tos/Calc: MID function|MID]], [[Documentation/How_Tos/Calc: PROPER function|PROPER]], [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]], [[Documentation/How_Tos/Calc: REPT function|REPT]], [[Documentation/How_Tos/Calc: RIGHT function|RIGHT]], [[Documentation/How_Tos/Calc: SEARCH function|SEARCH]], [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]], [[Documentation/How_Tos/Calc: T function|T]], [[Documentation/How_Tos/Calc: TEXT function|TEXT]], [[Documentation/How_Tos/Calc: TRIM function|TRIM]], [[Documentation/How_Tos/Calc: UPPER function|UPPER]], [[Documentation/How_Tos/Calc: VALUE function|VALUE]]
 
+
<noinclude>[[Category:Templates]]</noinclude>
==See also==
+
 
+
'''[[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]'''
+
 
+
 
+
[[Category:Documentation]]
+
[[Category:Calc]]
+
[[Category:How to]]
+
{{InterWiki Calc Functions listed by category}}
+
[[Category:Documentation/Reference]]
+

Latest revision as of 19:06, 26 September 2013

Array functions

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

Complex Number functions

The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.
· COMPLEX, IMABS, IMAGINARY, IMPOWER, IMARGUMENT, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMDIV, IMEXP, IMCONJUGATE, IMLN, IMLOG10, IMLOG2, IMPRODUCT, IMREAL, IMSEC, IMSECH, IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN


Database functions

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

Date & Time functions

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

Financial functions

The Financial functions provide common business calculations.
· AMORDEGRC, AMORLINC, DB, DDB, SLN, SYD, VDB
· CUMIPMT, CUMIPMT_ADD, CUMPRINC, CUMPRINC_ADD, FV, FVSCHEDULE, IPMT, IRR, ISPMT, MIRR, NPER, NPV, PMT, PPMT, PV, RATE, RRI, XIRR, XNPV
· ACCRINT, ACCRINTM, DISC, DURATION, DURATION_ADD, EFFECTIVE, EFFECT_ADD, INTRATE, MDURATION, NOMINAL, NOMINAL_ADD, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PRICE, PRICEDISC, PRICEMAT, RECEIVED, TBILLEQ, TBILLPRICE, TBILLYIELD, YIELD, YIELDDISC, YIELDMAT
· COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD
· DOLLARDE, DOLLARFR

Information functions

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

Logical functions

The Logical functions allow boolean logic decisions.
· AND, FALSE, IF, NOT, OR, TRUE, XOR

Mathematical functions

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, CSC, CSCH, SEC, SECH
· TRUNC, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND, INT, QUOTIENT, MOD
· EXP, POWER, LOG, LN, LOG10
· ABS, COMBIN, COMBINA, CONVERT, CONVERT_ADD, COUNTBLANK, COUNTIF, DELTA, ERF, ERFC, FACT, FACTDOUBLE, GCD, GCD_ADD, GESTEP, ISEVEN, ISODD, LCM, LCM_ADD, MULTINOMIAL, PRODUCT, RAND, RANDBETWEEN, SERIESSUM, SIGN, SQRT, SQRTPI, SUBTOTAL, SUM, SUMIF, SUMSQ
· BESSELI, BESSELJ, BESSELK, BESSELY

Number Conversion functions

The Number Conversion functions convert numbers between forms.
· BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
· ARABIC, BAHTTEXT, DECIMAL, ROMAN

Spreadsheet functions

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

Statistical functions

The Statistical functions provide statistical and probability calculations.
· AVEDEV, AVERAGE, AVERAGEA, COUNT, COUNTA, GEOMEAN, HARMEAN, MEDIAN, MODE, TRIMMEAN
· DEVSQ, KURT, SKEW, STDEV, STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA
· B, BETADIST, BETAINV, BINOMDIST, CHIDIST, CHISQDIST, CHIINV, CHISQINV, CHITEST, CONFIDENCE, CRITBINOM, EXPONDIST, FINV, FISHER, FISHERINV, FDIST, FTEST, GAMMA, GAMMAINV, GAMMALN, GAMMADIST, GAUSS, HYPGEOMDIST, LOGINV, LOGNORMDIST, NEGBINOMDIST, NORMINV, NORMDIST, NORMSINV, NORMSDIST, PERMUT, PERMUTATIONA, PHI, POISSON, PROB, STANDARDIZE, TDIST, TINV, TTEST, WEIBULL, ZTEST
· CORREL, COVAR, FORECAST, INTERCEPT, PEARSON, RSQ, SLOPE, STEYX
· LARGE, MAX, MAXA, MIN, MINA, PERCENTILE, PERCENTRANK, QUARTILE, RANK, SMALL

Text functions

The Text functions manipulate or return text.
· BASE, CHAR, CLEAN, CODE, CONCATENATE, DOLLAR, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TRIM, UPPER, VALUE
Personal tools