Difference between revisions of "Template:Calc functions alpha"
From Apache OpenOffice Wiki
Line 8: | Line 8: | ||
*[[Documentation/How_Tos/Calc: B function|B]], [[Documentation/How_Tos/Calc: BAHTTEXT function|BAHTTEXT]], [[Documentation/How_Tos/Calc: BASE function|BASE]], [[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: BETADIST function|BETADIST]], [[Documentation/How_Tos/Calc: BETAINV function|BETAINV]], [[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: BINOMDIST function|BINOMDIST]] | *[[Documentation/How_Tos/Calc: B function|B]], [[Documentation/How_Tos/Calc: BAHTTEXT function|BAHTTEXT]], [[Documentation/How_Tos/Calc: BASE function|BASE]], [[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: BETADIST function|BETADIST]], [[Documentation/How_Tos/Calc: BETAINV function|BETAINV]], [[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: BINOMDIST function|BINOMDIST]] | ||
− | *[[Documentation/How_Tos/Calc: CEILING function|CEILING]], [[Documentation/How_Tos/Calc: CELL function|CELL]], [[Documentation/How_Tos/Calc: CHAR function|CHAR]], [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]], [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]], [[Documentation/How_Tos/Calc: CHISQDIST function|CHISQDIST]], [[Documentation/How_Tos/Calc: CHITEST function|CHITEST]], [[Documentation/How_Tos/Calc: CHOOSE function|CHOOSE]], [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]], [[Documentation/How_Tos/Calc: CODE function|CODE]], [[Documentation/How_Tos/Calc: COLUMN function|COLUMN]], [[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]], [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]], [[Documentation/How_Tos/Calc: COMBINA function|COMBINA]], [[Documentation/How_Tos/Calc: COMPLEX function|COMPLEX]], [[Documentation/How_Tos/Calc: CONCATENATE function|CONCATENATE]], [[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]], [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]], [[Documentation/How_Tos/Calc: CONVERT_ADD function|CONVERT_ADD]], [[Documentation/How_Tos/Calc: CORREL function|CORREL]], [[Documentation/How_Tos/Calc: COS function|COS]], [[Documentation/How_Tos/Calc: COSH function|COSH]], [[Documentation/How_Tos/Calc: COT function|COT]], [[Documentation/How_Tos/Calc: COTH function|COTH]], [[Documentation/How_Tos/Calc: COUNT function|COUNT]], [[Documentation/How_Tos/Calc: COUNTA function|COUNTA]], [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]], [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]], [[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: COVAR function|COVAR]], [[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]], [[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: CURRENT function|CURRENT]] | + | *[[Documentation/How_Tos/Calc: CEILING function|CEILING]], [[Documentation/How_Tos/Calc: CELL function|CELL]], [[Documentation/How_Tos/Calc: CHAR function|CHAR]], [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]], [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]], [[Documentation/How_Tos/Calc: CHISQDIST function|CHISQDIST]], [[Documentation/How_Tos/Calc: CHISQINV function|CHISQINV]], [[Documentation/How_Tos/Calc: CHITEST function|CHITEST]], [[Documentation/How_Tos/Calc: CHOOSE function|CHOOSE]], [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]], [[Documentation/How_Tos/Calc: CODE function|CODE]], [[Documentation/How_Tos/Calc: COLUMN function|COLUMN]], [[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]], [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]], [[Documentation/How_Tos/Calc: COMBINA function|COMBINA]], [[Documentation/How_Tos/Calc: COMPLEX function|COMPLEX]], [[Documentation/How_Tos/Calc: CONCATENATE function|CONCATENATE]], [[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]], [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]], [[Documentation/How_Tos/Calc: CONVERT_ADD function|CONVERT_ADD]], [[Documentation/How_Tos/Calc: CORREL function|CORREL]], [[Documentation/How_Tos/Calc: COS function|COS]], [[Documentation/How_Tos/Calc: COSH function|COSH]], [[Documentation/How_Tos/Calc: COT function|COT]], [[Documentation/How_Tos/Calc: COTH function|COTH]], [[Documentation/How_Tos/Calc: COUNT function|COUNT]], [[Documentation/How_Tos/Calc: COUNTA function|COUNTA]], [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]], [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]], [[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: COVAR function|COVAR]], [[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]], [[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: CURRENT function|CURRENT]] |
*[[Documentation/How_Tos/Calc: DATE function|DATE]], [[Documentation/How_Tos/Calc: DATEVALUE function|DATEVALUE]], [[Documentation/How_Tos/Calc: DAVERAGE function|DAVERAGE]], [[Documentation/How_Tos/Calc: DAY function|DAY]], [[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: DB function|DB]], [[Documentation/How_Tos/Calc: DCOUNT function|DCOUNT]], [[Documentation/How_Tos/Calc: DCOUNTA function|DCOUNTA]], [[Documentation/How_Tos/Calc: DDB function|DDB]], [[Documentation/How_Tos/Calc: DDE function|DDE]], [[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: DECIMAL function|DECIMAL]], [[Documentation/How_Tos/Calc: DEGREES function|DEGREES]], [[Documentation/How_Tos/Calc: DELTA function|DELTA]], [[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]], [[Documentation/How_Tos/Calc: DGET function|DGET]], [[Documentation/How_Tos/Calc: DISC function|DISC]], [[Documentation/How_Tos/Calc: DMAX function|DMAX]], [[Documentation/How_Tos/Calc: DMIN function|DMIN]], [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: DOLLARDE function|DOLLARDE]], [[Documentation/How_Tos/Calc: DOLLARFR function|DOLLARFR]], [[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: DURATION function|DURATION]], [[Documentation/How_Tos/Calc: DURATION_ADD function|DURATION_ADD]], [[Documentation/How_Tos/Calc: DVAR function|DVAR]], [[Documentation/How_Tos/Calc: DVARP function|DVARP]] | *[[Documentation/How_Tos/Calc: DATE function|DATE]], [[Documentation/How_Tos/Calc: DATEVALUE function|DATEVALUE]], [[Documentation/How_Tos/Calc: DAVERAGE function|DAVERAGE]], [[Documentation/How_Tos/Calc: DAY function|DAY]], [[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: DB function|DB]], [[Documentation/How_Tos/Calc: DCOUNT function|DCOUNT]], [[Documentation/How_Tos/Calc: DCOUNTA function|DCOUNTA]], [[Documentation/How_Tos/Calc: DDB function|DDB]], [[Documentation/How_Tos/Calc: DDE function|DDE]], [[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: DECIMAL function|DECIMAL]], [[Documentation/How_Tos/Calc: DEGREES function|DEGREES]], [[Documentation/How_Tos/Calc: DELTA function|DELTA]], [[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]], [[Documentation/How_Tos/Calc: DGET function|DGET]], [[Documentation/How_Tos/Calc: DISC function|DISC]], [[Documentation/How_Tos/Calc: DMAX function|DMAX]], [[Documentation/How_Tos/Calc: DMIN function|DMIN]], [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: DOLLARDE function|DOLLARDE]], [[Documentation/How_Tos/Calc: DOLLARFR function|DOLLARFR]], [[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: DURATION function|DURATION]], [[Documentation/How_Tos/Calc: DURATION_ADD function|DURATION_ADD]], [[Documentation/How_Tos/Calc: DVAR function|DVAR]], [[Documentation/How_Tos/Calc: DVARP function|DVARP]] |
Revision as of 21:54, 22 December 2008
Calc functions listed alphabetically
You may also see a list of the functions listed by category.
- ABS, ACCRINT, ACCRINTM, ACOS, ACOSH, ACOT, ACOTH, ADDRESS, AMORDEGRC, AMORLINC, AND, ARABIC, AREAS, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, AVERAGEA
- B, BAHTTEXT, BASE, BESSELI, BESSELJ, BESSELK, BESSELY, BETADIST, BETAINV, BIN2DEC, BIN2HEX, BIN2OCT, BINOMDIST
- CEILING, CELL, CHAR, CHIDIST, CHIINV, CHISQDIST, CHISQINV, CHITEST, CHOOSE, CLEAN, CODE, COLUMN, COLUMNS, COMBIN, COMBINA, COMPLEX, CONCATENATE, CONFIDENCE, CONVERT, CONVERT_ADD, CORREL, COS, COSH, COT, COTH, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, COVAR, CRITBINOM, CUMIPMT, CUMIPMT_ADD, CUMPRINC, CUMPRINC_ADD, CURRENT
- DATE, DATEVALUE, DAVERAGE, DAY, DAYS, DAYS360, DAYSINMONTH, DAYSINYEAR, DB, DCOUNT, DCOUNTA, DDB, DDE, DEC2BIN, DEC2HEX, DEC2OCT, DECIMAL, DEGREES, DELTA, DEVSQ, DGET, DISC, DMAX, DMIN, DOLLAR, DOLLARDE, DOLLARFR, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DURATION, DURATION_ADD, DVAR, DVARP
- EASTERSUNDAY, EDATE, EFFECT_ADD, EFFECTIVE, EOMONTH, ERF, ERFC, ERRORTYPE, EVEN, EXACT, EXP, EXPONDIST
- FACT, FACTDOUBLE, FALSE, FDIST, FIND, FINV, FISHER, FISHERINV, FIXED, FLOOR, FORECAST, FORMULA, FREQUENCY, FTEST, FV, FVSCHEDULE
- IF, IMABS, IMAGINARY, IMARGUMENT, IMCONJUGATE, IMCOS, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSIN, IMSQRT, IMSUB, IMSUM, INDEX, INDIRECT, INFO, INT, INTERCEPT, INTRATE, IPMT, IRR, ISBLANK, ISERR, ISERROR, ISEVEN, ISEVEN, ISEVEN_ADD, ISFORMULA, ISLEAPYEAR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISODD, ISODD_ADD, ISPMT, ISREF, ISTEXT
- MATCH, MAX, MAXA, MDETERM, MDURATION, MEDIAN, MID, MIN, MINA, MINUTE, MINVERSE, MIRR, MMULT, MOD, MODE, MONTH, MONTHS, MROUND, MULTINOMIAL, MUNIT
- N, NA, NEGBINOMDIST, NETWORKDAYS, NOMINAL, NOMINAL_ADD, NORMDIST, NORMINV, NORMSDIST, NORMSINV, NOT, NOW, NPER, NPV
- PEARSON, PERCENTILE, PERCENTRANK, PERMUT, PERMUTATIONA, PHI, PI, PMT, POISSON, POWER, PPMT, PRICE, PRICEDISC, PRICEMAT, PROB, PRODUCT, PROPER, PV
- RADIANS, RAND, RANDBETWEEN, RANK, RATE, RECEIVED, REPLACE, REPT, RIGHT, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, RRI, RSQ
- SEARCH, SECOND, SERIESSUM, SHEET, SHEETS, SIGN, SIN, SINH, SKEW, SLN, SLOPE, SMALL, SQRT, SQRTPI, STANDARDIZE, STDEV, STDEVA, STDEVP, STDEVPA, STEYX, STYLE, SUBSTITUTE, SUBTOTAL, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, SYD
- T, TAN, TANH, TBILLEQ, TBILLPRICE, TBILLYIELD, TDIST, TEXT, TIME, TIMEVALUE, TINV, TODAY, TRANSPOSE, TREND, TRIM, TRIMMEAN, TRUE, TRUNC, TTEST, TYPE