Difference between revisions of "Template:Calc functions alpha"
From Apache OpenOffice Wiki
m (add (redlink) refs fot functions AverageIFS, CountIFS, SumIFS, XOR) |
(Adding new CSC CSCH and SECH SEC formulas) |
||
Line 3: | Line 3: | ||
*[[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: 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: COUNTIFS function|COUNTIFS]], [[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: COUNTIFS function|COUNTIFS]], [[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: CSC function|CSC]], [[Documentation/How_Tos/Calc: CSCH function|CSCH]], [[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]] | ||
Line 33: | Line 33: | ||
*[[Documentation/How_Tos/Calc: RADIANS function|RADIANS]], [[Documentation/How_Tos/Calc: RAND function|RAND]], [[Documentation/How_Tos/Calc: RANDBETWEEN function|RANDBETWEEN]], [[Documentation/How_Tos/Calc: RANK function|RANK]], [[Documentation/How_Tos/Calc: RATE function|RATE]], [[Documentation/How_Tos/Calc: RECEIVED function|RECEIVED]], [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]], [[Documentation/How_Tos/Calc: REPT function|REPT]], [[Documentation/How_Tos/Calc: RIGHT function|RIGHT]], [[Documentation/How_Tos/Calc: ROMAN function|ROMAN]], [[Documentation/How_Tos/Calc: ROUND function|ROUND]], [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]], [[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]], [[Documentation/How_Tos/Calc: ROW function|ROW]], [[Documentation/How_Tos/Calc: ROWS function|ROWS]], [[Documentation/How_Tos/Calc: RRI function|RRI]], [[Documentation/How_Tos/Calc: RSQ function|RSQ]] | *[[Documentation/How_Tos/Calc: RADIANS function|RADIANS]], [[Documentation/How_Tos/Calc: RAND function|RAND]], [[Documentation/How_Tos/Calc: RANDBETWEEN function|RANDBETWEEN]], [[Documentation/How_Tos/Calc: RANK function|RANK]], [[Documentation/How_Tos/Calc: RATE function|RATE]], [[Documentation/How_Tos/Calc: RECEIVED function|RECEIVED]], [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]], [[Documentation/How_Tos/Calc: REPT function|REPT]], [[Documentation/How_Tos/Calc: RIGHT function|RIGHT]], [[Documentation/How_Tos/Calc: ROMAN function|ROMAN]], [[Documentation/How_Tos/Calc: ROUND function|ROUND]], [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]], [[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]], [[Documentation/How_Tos/Calc: ROW function|ROW]], [[Documentation/How_Tos/Calc: ROWS function|ROWS]], [[Documentation/How_Tos/Calc: RRI function|RRI]], [[Documentation/How_Tos/Calc: RSQ function|RSQ]] | ||
− | *[[Documentation/How_Tos/Calc: SEARCH function|SEARCH]], [[Documentation/How_Tos/Calc: SECOND function|SECOND]], [[Documentation/How_Tos/Calc: SERIESSUM function|SERIESSUM]], [[Documentation/How_Tos/Calc: SHEET function|SHEET]], [[Documentation/How_Tos/Calc: SHEETS function|SHEETS]], [[Documentation/How_Tos/Calc: SIGN function|SIGN]], [[Documentation/How_Tos/Calc: SIN function|SIN]], [[Documentation/How_Tos/Calc: SINH function|SINH]], [[Documentation/How_Tos/Calc: SKEW function|SKEW]], [[Documentation/How_Tos/Calc: SLN function|SLN]], [[Documentation/How_Tos/Calc: SLOPE function|SLOPE]], [[Documentation/How_Tos/Calc: SMALL function|SMALL]], [[Documentation/How_Tos/Calc: SQRT function|SQRT]], [[Documentation/How_Tos/Calc: SQRTPI function|SQRTPI]], [[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: STYLE function|STYLE]], [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]], [[Documentation/How_Tos/Calc: SUBTOTAL function|SUBTOTAL]], [[Documentation/How_Tos/Calc: SUM function|SUM]], [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]], [[Documentation/How_Tos/Calc: SUMIFS function|SUMIFS]], [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]], [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]], [[Documentation/How_Tos/Calc: SUMX2MY2 function|SUMX2MY2]], [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]], [[Documentation/How_Tos/Calc: SUMXMY2 function|SUMXMY2]], [[Documentation/How_Tos/Calc: SYD function|SYD]] | + | *[[Documentation/How_Tos/Calc: SEC function|SEC]], [[Documentation/How_Tos/Calc: SECH function|SECH]], [[Documentation/How_Tos/Calc: SEARCH function|SEARCH]], [[Documentation/How_Tos/Calc: SECOND function|SECOND]], [[Documentation/How_Tos/Calc: SERIESSUM function|SERIESSUM]], [[Documentation/How_Tos/Calc: SHEET function|SHEET]], [[Documentation/How_Tos/Calc: SHEETS function|SHEETS]], [[Documentation/How_Tos/Calc: SIGN function|SIGN]], [[Documentation/How_Tos/Calc: SIN function|SIN]], [[Documentation/How_Tos/Calc: SINH function|SINH]], [[Documentation/How_Tos/Calc: SKEW function|SKEW]], [[Documentation/How_Tos/Calc: SLN function|SLN]], [[Documentation/How_Tos/Calc: SLOPE function|SLOPE]], [[Documentation/How_Tos/Calc: SMALL function|SMALL]], [[Documentation/How_Tos/Calc: SQRT function|SQRT]], [[Documentation/How_Tos/Calc: SQRTPI function|SQRTPI]], [[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: STYLE function|STYLE]], [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]], [[Documentation/How_Tos/Calc: SUBTOTAL function|SUBTOTAL]], [[Documentation/How_Tos/Calc: SUM function|SUM]], [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]], [[Documentation/How_Tos/Calc: SUMIFS function|SUMIFS]], [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]], [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]], [[Documentation/How_Tos/Calc: SUMX2MY2 function|SUMX2MY2]], [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]], [[Documentation/How_Tos/Calc: SUMXMY2 function|SUMXMY2]], [[Documentation/How_Tos/Calc: SYD function|SYD]] |
*[[Documentation/How_Tos/Calc: T function|T]], [[Documentation/How_Tos/Calc: TAN function|TAN]], [[Documentation/How_Tos/Calc: TANH function|TANH]], [[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: TDIST function|TDIST]], [[Documentation/How_Tos/Calc: TEXT function|TEXT]], [[Documentation/How_Tos/Calc: TIME function|TIME]], [[Documentation/How_Tos/Calc: TIMEVALUE function|TIMEVALUE]], [[Documentation/How_Tos/Calc: TINV function|TINV]], [[Documentation/How_Tos/Calc: TODAY function|TODAY]], [[Documentation/How_Tos/Calc: TRANSPOSE function|TRANSPOSE]], [[Documentation/How_Tos/Calc: TREND function|TREND]], [[Documentation/How_Tos/Calc: TRIM function|TRIM]], [[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]], [[Documentation/How_Tos/Calc: TRUE function|TRUE]], [[Documentation/How_Tos/Calc: TRUNC function|TRUNC]], [[Documentation/How_Tos/Calc: TTEST function|TTEST]], [[Documentation/How_Tos/Calc: TYPE function|TYPE]] | *[[Documentation/How_Tos/Calc: T function|T]], [[Documentation/How_Tos/Calc: TAN function|TAN]], [[Documentation/How_Tos/Calc: TANH function|TANH]], [[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: TDIST function|TDIST]], [[Documentation/How_Tos/Calc: TEXT function|TEXT]], [[Documentation/How_Tos/Calc: TIME function|TIME]], [[Documentation/How_Tos/Calc: TIMEVALUE function|TIMEVALUE]], [[Documentation/How_Tos/Calc: TINV function|TINV]], [[Documentation/How_Tos/Calc: TODAY function|TODAY]], [[Documentation/How_Tos/Calc: TRANSPOSE function|TRANSPOSE]], [[Documentation/How_Tos/Calc: TREND function|TREND]], [[Documentation/How_Tos/Calc: TRIM function|TRIM]], [[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]], [[Documentation/How_Tos/Calc: TRUE function|TRUE]], [[Documentation/How_Tos/Calc: TRUNC function|TRUNC]], [[Documentation/How_Tos/Calc: TTEST function|TTEST]], [[Documentation/How_Tos/Calc: TYPE function|TYPE]] |
Revision as of 07:30, 12 May 2013
- ABS, ACCRINT, ACCRINTM, ACOS, ACOSH, ACOT, ACOTH, ADDRESS, AMORDEGRC, AMORLINC, AND, ARABIC, AREAS, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, AVERAGEA, AVERAGEIFS
- 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, COUNTIFS, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, COVAR, CRITBINOM, CSC, CSCH, 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, IMCOSH, IMCSC, IMCSCH, IMCOT, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, IMSECH, IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN, 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
- SEC, SECH, 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, SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, SYD