Difference between revisions of "Template:Calc functions"

Revision as of 19:13, 10 September 2008

Calc functions listed by category

These pages are a complete rewrite of the Function Help for Calc, with links to other relevant topics. The descriptions aim 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 some explanatory notes on the category.

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, IMDIV, IMEXP, IMCONJUGATE, IMLN, IMLOG10, IMLOG2, IMPRODUCT, IMREAL, IMSIN, IMSUB, IMSUM, IMSQRT

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, EFFECTIVE, EFFECT_ADD, FV, FVSCHEDULE, IPMT, IRR, ISPMT, MIRR, NPER, NPV, PMT, PPMT, PV, RATE, RRI, XIRR, XNPV

· ACCRINT, ACCRINTM, DISC, DURATION, DURATION_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

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

· 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, CHIINV, CHITEST, CONFIDENCE, CRITBINOM, EXPONDIST, FINV, FISHER, FISHERINV, FDIST, FTEST, 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

@@ Line 53: / Line 53: @@
 :[[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: Statistical functions|Statistical functions]]'''
-:The Statistical functions provide statistical and probability calculations.
-:[[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: CHIDIST function|CHIDIST]] [[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: 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]]'''
 :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]]
+:<b>&middot; </b>[[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]]
+:<b>&middot; </b>[[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]]
+:<b>&middot; </b>[[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: Statistical functions|Statistical functions]]'''
+:The Statistical functions provide statistical and probability calculations.
+:<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: 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: 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: 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]]
 '''[[Documentation/How_Tos/Calc: Text functions|Text functions]]'''

Difference between revisions of "Template:Calc functions"

Revision as of 19:13, 10 September 2008

Calc functions listed by category

Views

Personal tools

Navigation

Search

Tools

In other languages