Difference between revisions of "Template:Calc functions alpha"
From Apache OpenOffice Wiki
Line 14: | Line 14: | ||
*[[Documentation/How_Tos/Calc: EASTERSUNDAY function|EASTERSUNDAY]], [[Documentation/How_Tos/Calc: EDATE function|EDATE]], [[Documentation/How_Tos/Calc: EFFECT_ADD function|EFFECT_ADD]], [[Documentation/How_Tos/Calc: EFFECTIVE function|EFFECTIVE]], [[Documentation/How_Tos/Calc: EOMONTH function|EOMONTH]], [[Documentation/How_Tos/Calc: ERF function|ERF]], [[Documentation/How_Tos/Calc: ERFC function|ERFC]], [[Documentation/How_Tos/Calc: ERRORTYPE function|ERRORTYPE]], [[Documentation/How_Tos/Calc: EVEN function|EVEN]], [[Documentation/How_Tos/Calc: EXACT function|EXACT]], [[Documentation/How_Tos/Calc: EXP function|EXP]], [[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]] | *[[Documentation/How_Tos/Calc: EASTERSUNDAY function|EASTERSUNDAY]], [[Documentation/How_Tos/Calc: EDATE function|EDATE]], [[Documentation/How_Tos/Calc: EFFECT_ADD function|EFFECT_ADD]], [[Documentation/How_Tos/Calc: EFFECTIVE function|EFFECTIVE]], [[Documentation/How_Tos/Calc: EOMONTH function|EOMONTH]], [[Documentation/How_Tos/Calc: ERF function|ERF]], [[Documentation/How_Tos/Calc: ERFC function|ERFC]], [[Documentation/How_Tos/Calc: ERRORTYPE function|ERRORTYPE]], [[Documentation/How_Tos/Calc: EVEN function|EVEN]], [[Documentation/How_Tos/Calc: EXACT function|EXACT]], [[Documentation/How_Tos/Calc: EXP function|EXP]], [[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]] | ||
− | *[[Documentation/How_Tos/Calc: FACT function|FACT]], [[Documentation/How_Tos/Calc: FACTDOUBLE function|FACTDOUBLE]], [[Documentation/How_Tos/Calc: FALSE function|FALSE]], [[Documentation/How_Tos/Calc: FDIST function|FDIST]], [[Documentation/How_Tos/Calc: FIND function|FIND]], [[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: FIXED function|FIXED]], [[Documentation/How_Tos/Calc: FLOOR function|FLOOR]], [[Documentation/How_Tos/Calc: FORECAST function|FORECAST]], [[Documentation/How_Tos/Calc: FORMULA function|FORMULA]], [[Documentation/How_Tos/Calc: FREQUENCY function|FREQUENCY]], [[Documentation/How_Tos/Calc: FTEST function|FTEST]], [[Documentation/How_Tos/Calc: FV function|FV]] | + | *[[Documentation/How_Tos/Calc: FACT function|FACT]], [[Documentation/How_Tos/Calc: FACTDOUBLE function|FACTDOUBLE]], [[Documentation/How_Tos/Calc: FALSE function|FALSE]], [[Documentation/How_Tos/Calc: FDIST function|FDIST]], [[Documentation/How_Tos/Calc: FIND function|FIND]], [[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: FIXED function|FIXED]], [[Documentation/How_Tos/Calc: FLOOR function|FLOOR]], [[Documentation/How_Tos/Calc: FORECAST function|FORECAST]], [[Documentation/How_Tos/Calc: FORMULA function|FORMULA]], [[Documentation/How_Tos/Calc: FREQUENCY function|FREQUENCY]], [[Documentation/How_Tos/Calc: FTEST function|FTEST]], [[Documentation/How_Tos/Calc: FV function|FV]], [[Documentation/How_Tos/Calc: FVSCHEDULE function|FVSCHEDULE]] |
− | *[[Documentation/How_Tos/Calc: | + | *[[Documentation/How_Tos/Calc: GAMMA function|GAMMA]], [[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]], [[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]], [[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]], [[Documentation/How_Tos/Calc: GAUSS function|GAUSS]], [[Documentation/How_Tos/Calc: GCD function|GCD]], [[Documentation/How_Tos/Calc: GCD_ADD function|GCD_ADD]], [[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]], [[Documentation/How_Tos/Calc: GESTEP function|GESTEP]], [[Documentation/How_Tos/Calc: GROWTH function|GROWTH]] |
*[[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]], [[Documentation/How_Tos/Calc: HEX2BIN function|HEX2BIN]], [[Documentation/How_Tos/Calc: HEX2DEC function|HEX2DEC]], [[Documentation/How_Tos/Calc: HEX2OCT function|HEX2OCT]], [[Documentation/How_Tos/Calc: HLOOKUP function|HLOOKUP]], [[Documentation/How_Tos/Calc: HOUR function|HOUR]], [[Documentation/How_Tos/Calc: HYPERLINK function|HYPERLINK]], [[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]] | *[[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]], [[Documentation/How_Tos/Calc: HEX2BIN function|HEX2BIN]], [[Documentation/How_Tos/Calc: HEX2DEC function|HEX2DEC]], [[Documentation/How_Tos/Calc: HEX2OCT function|HEX2OCT]], [[Documentation/How_Tos/Calc: HLOOKUP function|HLOOKUP]], [[Documentation/How_Tos/Calc: HOUR function|HOUR]], [[Documentation/How_Tos/Calc: HYPERLINK function|HYPERLINK]], [[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]] |
Revision as of 21:09, 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, 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