Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
Javier Lopez (Talk | contribs) |
Javier Lopez (Talk | contribs) |
||
| Line 9: | Line 9: | ||
| − | ===== '''[Documentation/How_Tos/Calc: Database functions|Database functions]]''' ===== | + | ===== '''[[Documentation/How_Tos/Calc: Database functions|Database functions]]''' ===== |
:The Database functions are used to extract information from Calc data tables, where data is organised in rows. | :The Database functions are used to extract information from Calc data tables, where data is organised in rows. | ||
:<b>· </b>[[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]] | :<b>· </b>[[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: Date & Time functions|Date & Time functions]]''' | + | ===== '''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]''' ===== |
:The Date & Time functions are used to manipulate dates and times. | :The Date & Time functions are used to manipulate dates and times. | ||
:<b>· </b>[[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]] | :<b>· </b>[[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: Financial functions|Financial functions]]''' | + | ===== '''[[Documentation/How_Tos/Calc: Financial functions|Financial functions]]''' ===== |
:The Financial functions provide common business calculations. | :The Financial functions provide common business calculations. | ||
:<b>· </b>[[Documentation/How_Tos/Calc: AMORDEGRC function|AMORDEGRC]], [[Documentation/How_Tos/Calc: AMORLINC function|AMORLINC]], [[Documentation/How_Tos/Calc: DB function|DB]], [[Documentation/How_Tos/Calc: DDB function|DDB]], [[Documentation/How_Tos/Calc: SLN function|SLN]], [[Documentation/How_Tos/Calc: SYD function|SYD]], [[Documentation/How_Tos/Calc: VDB function|VDB]] | :<b>· </b>[[Documentation/How_Tos/Calc: AMORDEGRC function|AMORDEGRC]], [[Documentation/How_Tos/Calc: AMORLINC function|AMORLINC]], [[Documentation/How_Tos/Calc: DB function|DB]], [[Documentation/How_Tos/Calc: DDB function|DDB]], [[Documentation/How_Tos/Calc: SLN function|SLN]], [[Documentation/How_Tos/Calc: SYD function|SYD]], [[Documentation/How_Tos/Calc: VDB function|VDB]] | ||
| Line 25: | Line 25: | ||
:<b>· </b>[[Documentation/How_Tos/Calc: DOLLARDE function|DOLLARDE]], [[Documentation/How_Tos/Calc: DOLLARFR function|DOLLARFR]] | :<b>· </b>[[Documentation/How_Tos/Calc: DOLLARDE function|DOLLARDE]], [[Documentation/How_Tos/Calc: DOLLARFR function|DOLLARFR]] | ||
| − | '''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''' | + | ===== '''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''' ===== |
:The Information functions return information about cells, such as whether they contain text or a formula, etc. | :The Information functions return information about cells, such as whether they contain text or a formula, etc. | ||
:<b>· </b>[[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]] | :<b>· </b>[[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]] | ||
| − | '''[[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>· </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]] | :<b>· </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>· </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>· </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]] | ||
Revision as of 13:16, 3 May 2013
Contents
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
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
- 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, 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
