Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
| Line 65: | Line 65: | ||
:<b>· </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>· </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>· </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>· </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>· </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>· </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: 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>· </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>· </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>· </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>· </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]] | ||
Revision as of 21:36, 22 December 2008
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 functions in alphabetic order.
- 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
- 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
- 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, DAYSINMONTH, DAYSINYEAR, WEEKS, WEEKSINYEAR, WEEKNUM, WEEKNUM_ADD, MONTHS, YEARS, ISLEAPYEAR, EASTERSUNDAY, YEARFRAC
- 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
- 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 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
- The Number Conversion functions convert numbers between forms.
- · BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
- · ARABIC, BAHTTEXT, DECIMAL, ROMAN
- 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 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, 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
- 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
