Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
m (Documentation/How Tos/Calc: Functions listed by category moved to Template:Calc functions: move reference material to template) |
(remove header/footer info from template) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
'''[[Documentation/How_Tos/Calc: Array functions|Array functions]]''' | '''[[Documentation/How_Tos/Calc: Array functions|Array functions]]''' | ||
:The Array functions operate on and return entire tables of data. | :The Array functions operate on and return entire tables of data. | ||
| Line 72: | Line 62: | ||
:The Text functions manipulate or return text. | :The Text functions manipulate or return text. | ||
:<b>· </b>[[Documentation/How_Tos/Calc: BASE function|BASE]], [[Documentation/How_Tos/Calc: CHAR function|CHAR]], [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]], [[Documentation/How_Tos/Calc: CODE function|CODE]], [[Documentation/How_Tos/Calc: CONCATENATE function|CONCATENATE]], [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: EXACT function|EXACT]], [[Documentation/How_Tos/Calc: FIND function|FIND]], [[Documentation/How_Tos/Calc: FIXED function|FIXED]], [[Documentation/How_Tos/Calc: LEFT function|LEFT]], [[Documentation/How_Tos/Calc: LEN function|LEN]], [[Documentation/How_Tos/Calc: LOWER function|LOWER]], [[Documentation/How_Tos/Calc: MID function|MID]], [[Documentation/How_Tos/Calc: PROPER function|PROPER]], [[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: SEARCH function|SEARCH]], [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]], [[Documentation/How_Tos/Calc: T function|T]], [[Documentation/How_Tos/Calc: TEXT function|TEXT]], [[Documentation/How_Tos/Calc: TRIM function|TRIM]], [[Documentation/How_Tos/Calc: UPPER function|UPPER]], [[Documentation/How_Tos/Calc: VALUE function|VALUE]] | :<b>· </b>[[Documentation/How_Tos/Calc: BASE function|BASE]], [[Documentation/How_Tos/Calc: CHAR function|CHAR]], [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]], [[Documentation/How_Tos/Calc: CODE function|CODE]], [[Documentation/How_Tos/Calc: CONCATENATE function|CONCATENATE]], [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: EXACT function|EXACT]], [[Documentation/How_Tos/Calc: FIND function|FIND]], [[Documentation/How_Tos/Calc: FIXED function|FIXED]], [[Documentation/How_Tos/Calc: LEFT function|LEFT]], [[Documentation/How_Tos/Calc: LEN function|LEN]], [[Documentation/How_Tos/Calc: LOWER function|LOWER]], [[Documentation/How_Tos/Calc: MID function|MID]], [[Documentation/How_Tos/Calc: PROPER function|PROPER]], [[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: SEARCH function|SEARCH]], [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]], [[Documentation/How_Tos/Calc: T function|T]], [[Documentation/How_Tos/Calc: TEXT function|TEXT]], [[Documentation/How_Tos/Calc: TRIM function|TRIM]], [[Documentation/How_Tos/Calc: UPPER function|UPPER]], [[Documentation/How_Tos/Calc: VALUE function|VALUE]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 05:15, 28 January 2009
- 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, IMDIV, IMEXP, IMCONJUGATE, IMLN, IMLOG10, IMLOG2, IMPRODUCT, IMREAL, IMSIN, IMSUB, IMSUM, IMSQRT
- 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
- · 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
