Difference between revisions of "Template:Calc functions"

== Calc functions listed by category ==

These pages are a complete rewrite of the Function Help for Calc. Not all functions are included yet. The aim is for descriptions to be more precise, complete and consistent than before.

:[[Documentation/How_Tos/Calc: DCOUNT function|DCOUNT]], [[Documentation/How_Tos/Calc: DCOUNTA function|DCOUNTA]], [[Documentation/How_Tos/Calc: DGET function|DGET]], [[Documentation/How_Tos/Calc: DMAX function|DMAX]], [[Documentation/How_Tos/Calc: DMIN function|DMIN]], [[Documentation/How_Tos/Calc: DAVERAGE function|DAVERAGE]], [[Documentation/How_Tos/Calc: DPRODUCT function|DPRODUCT]], [[Documentation/How_Tos/Calc: DSTDEV function|DSTDEV]], [[Documentation/How_Tos/Calc: DSTDEVP function|DSTDEVP]], [[Documentation/How_Tos/Calc: DSUM function|DSUM]], [[Documentation/How_Tos/Calc: DVAR function|DVAR]], [[Documentation/How_Tos/Calc: DVARP function|DVARP]]

:[[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: CELL function|CELL]], [[Documentation/How_Tos/Calc: CURRENT function|CURRENT]], [[Documentation/How_Tos/Calc: FORMULA function|FORMULA]], [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]], [[Documentation/How_Tos/Calc: ISERR function|ISERR]], [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISEVEN_ADD function|ISEVEN_ADD]], [[Documentation/How_Tos/Calc: ISFORMULA function|ISFORMULA]], [[Documentation/How_Tos/Calc: ISLOGICAL function|ISLOGICAL]], [[Documentation/How_Tos/Calc: ISNA function|ISNA]], [[Documentation/How_Tos/Calc: ISNONTEXT function|ISNONTEXT]], [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: ISODD_ADD function|ISODD_ADD]], [[Documentation/How_Tos/Calc: ISREF function|ISREF]], [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]], [[Documentation/How_Tos/Calc: N function|N]], [[Documentation/How_Tos/Calc: NA function|NA]], [[Documentation/How_Tos/Calc: TYPE function|TYPE]]  

:The Logical functions include boolean logic '''AND''', '''OR''', '''NOT''' functions, and functions such as '''IF''' which test a logical result.  

:[[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: 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: CONVERT_ADD function|CONVERT_ADD]], [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]], [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]], [[Documentation/How_Tos/Calc: DELTA function|DELTA]], [[Documentation/How_Tos/Calc: ERF function|ERF]], [[Documentation/How_Tos/Calc: ERFC function|ERFC]], [[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: GESTEP function|GESTEP]], [[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: BESSELI function|BESSELI]], [[Documentation/How_Tos/Calc: BESSELJ function|BESSELJ]], [[Documentation/How_Tos/Calc: BESSELK function|BESSELK]], [[Documentation/How_Tos/Calc: BESSELY function|BESSELY]]

:[[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]], [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]], [[Documentation/How_Tos/Calc: BIN2OCT function|BIN2OCT]], [[Documentation/How_Tos/Calc: DEC2BIN function|DEC2BIN]], [[Documentation/How_Tos/Calc: DEC2HEX function|DEC2HEX]], [[Documentation/How_Tos/Calc: DEC2OCT function|DEC2OCT]], [[Documentation/How_Tos/Calc: HEX2BIN function|HEX2BIN]], [[Documentation/How_Tos/Calc: HEX2DEC function|HEX2DEC]], [[Documentation/How_Tos/Calc: HEX2OCT function|HEX2OCT]], [[Documentation/How_Tos/Calc: OCT2BIN function|OCT2BIN]], [[Documentation/How_Tos/Calc: OCT2DEC function|OCT2DEC]], [[Documentation/How_Tos/Calc: OCT2HEX function|OCT2HEX]]

:[[Documentation/How_Tos/Calc: ARABIC function|ARABIC]], [[Documentation/How_Tos/Calc: BAHTTEXT function|BAHTTEXT]], [[Documentation/How_Tos/Calc: DECIMAL function|DECIMAL]], [[Documentation/How_Tos/Calc: ROMAN function|ROMAN]]

'''[[Documentation/How_Tos/Calc: Array functions|Array functions]]'''

:The Array functions operate on and return entire tables of data.  

:[[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: AVEDEV function|AVEDEV]] [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]] [[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]] [[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: COUNT function|COUNT]] [[Documentation/How_Tos/Calc: COUNTA function|COUNTA]] [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]] [[Documentation/How_Tos/Calc: CHITEST function|CHITEST]] [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]] [[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]] [[Documentation/How_Tos/Calc: CORREL function|CORREL]] [[Documentation/How_Tos/Calc: COVAR function|COVAR]] [[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]] [[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]] [[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: FORECAST function|FORECAST]] [[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: GEOMEAN function|GEOMEAN]] [[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]] [[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]] [[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]] [[Documentation/How_Tos/Calc: KURT function|KURT]] [[Documentation/How_Tos/Calc: LARGE function|LARGE]] [[Documentation/How_Tos/Calc: LOGINV function|LOGINV]] [[Documentation/How_Tos/Calc: LOGNORMDIST function|LOGNORMDIST]] [[Documentation/How_Tos/Calc: MAX function|MAX]] [[Documentation/How_Tos/Calc: MAXA function|MAXA]] [[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]] [[Documentation/How_Tos/Calc: MIN function|MIN]] [[Documentation/How_Tos/Calc: MINA function|MINA]] [[Documentation/How_Tos/Calc: MODE function|MODE]] [[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: PEARSON function|PEARSON]] [[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]] [[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]] [[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: QUARTILE function|QUARTILE]] [[Documentation/How_Tos/Calc: RANK function|RANK]] [[Documentation/How_Tos/Calc: RSQ function|RSQ]] [[Documentation/How_Tos/Calc: SKEW function|SKEW]] [[Documentation/How_Tos/Calc: SLOPE function|SLOPE]] [[Documentation/How_Tos/Calc: SMALL function|SMALL]] [[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]] [[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: STEYX function|STEYX]] [[Documentation/How_Tos/Calc: TDIST function|TDIST]] [[Documentation/How_Tos/Calc: TINV function|TINV]] [[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]] [[Documentation/How_Tos/Calc: TTEST function|TTEST]] [[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]] [[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]] [[Documentation/How_Tos/Calc: ZTEST function|ZTEST]]

 

'''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]'''

:[[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: 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]]

 

 

 

[[Category:Documentation]]

[[fr:Documentation/FR/Calc/Fonctions listees par categories]]