Difference between revisions of "Documentation/How Tos/Calc: Functions listed by category"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
(3 intermediate revisions by 2 users not shown) | |||
Line 11: | Line 11: | ||
{{Calc_functions}} | {{Calc_functions}} | ||
− | + | {{SeeAlso|EN| | |
+ | *[[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
+ | }} | ||
− | |||
− | + | [[Category:Documentation/Reference/Calc]] | |
− | [[Category:Documentation/ | ||
[[Category:Calc]] | [[Category:Calc]] | ||
+ | [[Category: Documentation/Reference]] | ||
{{InterWiki Calc Functions listed by category}} | {{InterWiki Calc Functions listed by category}} | ||
{{PDL1}} | {{PDL1}} |
Latest revision as of 09:24, 17 July 2018
These pages are a complete rewrite of the Function Help for Calc, with links to other relevant topics. The aim is to have more detail and support than the Help pages for other major spreadsheets.
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 explanatory notes on the category, or
- see a list of functions in alphabetic order.
- 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 Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.
- · COMPLEX, IMABS, IMAGINARY, IMPOWER, IMARGUMENT, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMDIV, IMEXP, IMCONJUGATE, IMLN, IMLOG10, IMLOG2, IMPRODUCT, IMREAL, IMSEC, IMSECH, IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN
- 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.
- · AMORDEGRC, AMORLINC, DB, DDB, SLN, SYD, VDB
- · CUMIPMT, CUMIPMT_ADD, CUMPRINC, CUMPRINC_ADD, FV, FVSCHEDULE, IPMT, IRR, ISPMT, MIRR, NPER, NPV, PMT, PPMT, PV, RATE, RRI, XIRR, XNPV
- · ACCRINT, ACCRINTM, DISC, DURATION, DURATION_ADD, EFFECTIVE, EFFECT_ADD, INTRATE, MDURATION, NOMINAL, NOMINAL_ADD, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PRICE, PRICEDISC, PRICEMAT, RECEIVED, TBILLEQ, TBILLPRICE, TBILLYIELD, YIELD, YIELDDISC, YIELDMAT
- · COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD
- · DOLLARDE, DOLLARFR
- 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 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, CSC, CSCH, SEC, SECH
- · 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 'Spreadsheet' functions find values in tables, or cell references.
- · ADDRESS, CHOOSE, HLOOKUP, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, VLOOKUP
- · AREAS, COLUMN, COLUMNS, ERRORTYPE, INFO, ROW, ROWS, SHEET, SHEETS
- · DDE, HYPERLINK, STYLE
- The Statistical functions provide statistical and probability calculations.
- · AVEDEV, AVERAGE, AVERAGEA, COUNT, COUNTA, GEOMEAN, HARMEAN, MEDIAN, MODE, TRIMMEAN
- · DEVSQ, KURT, SKEW, STDEV, STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA
- · B, BETADIST, BETAINV, BINOMDIST, CHIDIST, CHISQDIST, CHIINV, CHISQINV, CHITEST, CONFIDENCE, CRITBINOM, EXPONDIST, FINV, FISHER, FISHERINV, FDIST, FTEST, GAMMA, GAMMAINV, GAMMALN, GAMMADIST, GAUSS, HYPGEOMDIST, LOGINV, LOGNORMDIST, NEGBINOMDIST, NORMINV, NORMDIST, NORMSINV, NORMSDIST, PERMUT, PERMUTATIONA, PHI, POISSON, PROB, STANDARDIZE, TDIST, TINV, TTEST, WEIBULL, ZTEST
- · CORREL, COVAR, FORECAST, INTERCEPT, PEARSON, RSQ, SLOPE, STEYX
- · LARGE, MAX, MAXA, MIN, MINA, PERCENTILE, PERCENTRANK, QUARTILE, RANK, SMALL
- The Text functions manipulate or return text.
- · ASC, BASE, CHAR, CLEAN, CODE, CONCATENATE, DOLLAR, EXACT, FIND, FIXED, JIS, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TRIM, UNICHAR, UNICODE, UPPER, VALUE
- · ARABIC, BAHTTEXT, DECIMAL, ROMAN
- (in category Number Conversion functions)
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}
Content on this page is licensed under the Public Documentation License (PDL). |