Documentation/How Tos/Calc: Functions listed alphabetically

From OpenOffice.org Wiki

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

• GAMMA, GAMMADIST, GAMMAINV, GAMMALN, GAUSS, GCD, GCD_ADD, GEOMEAN, GESTEP, GROWTH

• HARMEAN, HEX2BIN, HEX2DEC, HEX2OCT, HLOOKUP, HOUR, HYPERLINK, HYPGEOMDIST

• 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

• KURT

• LARGE, LCM, LCM_ADD, LEFT, LEN, LINEST, LN, LOG, LOG10, LOGEST, LOGINV, LOGNORMDIST, LOOKUP, LOWER

• 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

• OCT2BIN, OCT2DEC, OCT2HEX, ODD, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, OFFSET, OR

• PEARSON, PERCENTILE, PERCENTRANK, PERMUT, PERMUTATIONA, PHI, PI, PMT, POISSON, POWER, PPMT, PRICE, PRICEDISC, PRICEMAT, PROB, PRODUCT, PROPER, PV

• QUARTILE, QUOTIENT

• 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

• UPPER

• VALUE, VAR, VARA, VARP, VARPA, VDB, VLOOKUP

• WEEKDAY, WEEKNUM, WEEKNUM_ADD, WEEKS, WEEKSINYEAR, WEIBULL, WORKDAY

• XIRR, XNPV

• YEAR, YEARFRAC, YEARS, YIELD, YIELDDISC, YIELDMAT

• ZTEST

---

See Also

• Functions listed by category