Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
m |
(Financial functions added) |
||
Line 22: | Line 22: | ||
'''[[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. | ||
+ | :[[Documentation/How_Tos/Calc: ACCRINT function|ACCRINT]], [[Documentation/How_Tos/Calc: ACCRINTM function|ACCRINTM]], [[Documentation/How_Tos/Calc: AMORDEGRC function|AMORDEGRC]], [[Documentation/How_Tos/Calc: AMORLINC function|AMORLINC]], [[Documentation/How_Tos/Calc: COUPDAYBS function|COUPDAYBS]], [[Documentation/How_Tos/Calc: COUPDAYS function|COUPDAYS]], [[Documentation/How_Tos/Calc: COUPDAYSNC function|COUPDAYSNC]], [[Documentation/How_Tos/Calc: COUPNCD function|COUPNCD]], [[Documentation/How_Tos/Calc: COUPNUM function|COUPNUM]], [[Documentation/How_Tos/Calc: COUPPCD function|COUPPCD]], [[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]], [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]], [[Documentation/How_Tos/Calc: CUMPRINC function|CUMPRINC]], [[Documentation/How_Tos/Calc: CUMPRINC_ADD function|CUMPRINC_ADD]], [[Documentation/How_Tos/Calc: DB function|DB]], [[Documentation/How_Tos/Calc: DDB function|DDB]], [[Documentation/How_Tos/Calc: DISC function|DISC]], [[Documentation/How_Tos/Calc: DOLLARDE function|DOLLARDE]], [[Documentation/How_Tos/Calc: DOLLARFR function|DOLLARFR]], [[Documentation/How_Tos/Calc: DURATION function|DURATION]], [[Documentation/How_Tos/Calc: DURATION_ADD function|DURATION_ADD]], [[Documentation/How_Tos/Calc: EFFECTIVE function|EFFECTIVE]], [[Documentation/How_Tos/Calc: EFFECT_ADD function|EFFECT_ADD]], [[Documentation/How_Tos/Calc: FV function|FV]], [[Documentation/How_Tos/Calc: FVSCHEDULE function|FVSCHEDULE]], [[Documentation/How_Tos/Calc: INTRATE function|INTRATE]], [[Documentation/How_Tos/Calc: IPMT function|IPMT]], [[Documentation/How_Tos/Calc: IRR function|IRR]], [[Documentation/How_Tos/Calc: ISPMT function|ISPMT]], [[Documentation/How_Tos/Calc: MDURATION function|MDURATION]], [[Documentation/How_Tos/Calc: MIRR function|MIRR]], [[Documentation/How_Tos/Calc: NOMINAL function|NOMINAL]], [[Documentation/How_Tos/Calc: NOMINAL_ADD function|NOMINAL_ADD]], [[Documentation/How_Tos/Calc: NPER function|NPER]], [[Documentation/How_Tos/Calc: NPV function|NPV]], [[Documentation/How_Tos/Calc: ODDFPRICE function|ODDFPRICE]], [[Documentation/How_Tos/Calc: ODDFYIELD function|ODDFYIELD]], [[Documentation/How_Tos/Calc: ODDLPRICE function|ODDLPRICE]], [[Documentation/How_Tos/Calc: ODDLYIELD function|ODDLYIELD]], [[Documentation/How_Tos/Calc: PMT function|PMT]], [[Documentation/How_Tos/Calc: PPMT function|PPMT]], [[Documentation/How_Tos/Calc: PRICE function|PRICE]], [[Documentation/How_Tos/Calc: PRICEDISC function|PRICEDISC]], [[Documentation/How_Tos/Calc: PRICEMAT function|PRICEMAT]], [[Documentation/How_Tos/Calc: PV function|PV]], [[Documentation/How_Tos/Calc: RATE function|RATE]], [[Documentation/How_Tos/Calc: RECEIVED function|RECEIVED]], [[Documentation/How_Tos/Calc: RRI function|RRI]], [[Documentation/How_Tos/Calc: SLN function|SLN]], [[Documentation/How_Tos/Calc: SYD function|SYD]], [[Documentation/How_Tos/Calc: TBILLEQ function|TBILLEQ]], [[Documentation/How_Tos/Calc: TBILLPRICE function|TBILLPRICE]], [[Documentation/How_Tos/Calc: TBILLYIELD function|TBILLYIELD]], [[Documentation/How_Tos/Calc: VDB function|VDB]], [[Documentation/How_Tos/Calc: XIRR function|XIRR]], [[Documentation/How_Tos/Calc: XNPV function|XNPV]], [[Documentation/How_Tos/Calc: YIELD function|YIELD]], [[Documentation/How_Tos/Calc: YIELDDISC function|YIELDDISC]], [[Documentation/How_Tos/Calc: YIELDMAT function|YIELDMAT]] | ||
'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''' | '''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''' |
Revision as of 12:30, 27 July 2008
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.
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.
- 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.
- ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMIPMT, CUMIPMT_ADD, CUMPRINC, CUMPRINC_ADD, DB, DDB, DISC, DOLLARDE, DOLLARFR, DURATION, DURATION_ADD, EFFECTIVE, EFFECT_ADD, FV, FVSCHEDULE, INTRATE, IPMT, IRR, ISPMT, MDURATION, MIRR, NOMINAL, NOMINAL_ADD, NPER, NPV, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PMT, PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RATE, RECEIVED, RRI, SLN, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, VDB, XIRR, XNPV, YIELD, YIELDDISC, YIELDMAT
- 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 Logical functions include boolean logic AND, OR, NOT functions, and functions such as IF which test a logical result.
- AND, FALSE, IF, NOT, OR, TRUE
- 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 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 Statistical functions provide statistical and probability calculations.
- AVEDEV AVERAGE AVERAGEA B BETADIST BETAINV BINOMDIST COUNT COUNTA CHIDIST CHIINV CHITEST CONFIDENCE CORREL COVAR CRITBINOM DEVSQ EXPONDIST FINV FISHER FISHERINV FDIST FORECAST FTEST GAMMAINV GAMMALN GAMMADIST GAUSS GEOMEAN HARMEAN HYPGEOMDIST INTERCEPT KURT LARGE LOGINV LOGNORMDIST MAX MAXA MEDIAN MIN MINA MODE NEGBINOMDIST NORMINV NORMDIST NORMSINV NORMSDIST PEARSON PERCENTILE PERCENTRANK PERMUT PERMUTATIONA PHI POISSON PROB QUARTILE RANK RSQ SKEW SLOPE SMALL STANDARDIZE STDEV STDEVA STDEVP STDEVPA STEYX TDIST TINV TRIMMEAN TTEST VAR VARA VARP VARPA WEIBULL ZTEST