Difference between revisions of "Template:Calc functions alpha"
From Apache OpenOffice Wiki
(remove trim) |
(add new imaginary functions) |
||
Line 15: | Line 15: | ||
*[[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]] | ||
− | *[[Documentation/How_Tos/Calc: IF function|IF]], [[Documentation/How_Tos/Calc: IMABS function|IMABS]], [[Documentation/How_Tos/Calc: IMAGINARY function|IMAGINARY]], [[Documentation/How_Tos/Calc: IMARGUMENT function|IMARGUMENT]], [[Documentation/How_Tos/Calc: IMCONJUGATE function|IMCONJUGATE]], [[Documentation/How_Tos/Calc: IMCOS function|IMCOS]], [[Documentation/How_Tos/Calc: IMDIV function|IMDIV]], [[Documentation/How_Tos/Calc: IMEXP function|IMEXP]], [[Documentation/How_Tos/Calc: IMLN function|IMLN]], [[Documentation/How_Tos/Calc: IMLOG10 function|IMLOG10]], [[Documentation/How_Tos/Calc: IMLOG2 function|IMLOG2]], [[Documentation/How_Tos/Calc: IMPOWER function|IMPOWER]], [[Documentation/How_Tos/Calc: IMPRODUCT function|IMPRODUCT]], [[Documentation/How_Tos/Calc: IMREAL function|IMREAL]], [[Documentation/How_Tos/Calc: IMSIN function|IMSIN]], [[Documentation/How_Tos/Calc: IMSQRT function|IMSQRT]], [[Documentation/How_Tos/Calc: IMSUB function|IMSUB]], [[Documentation/How_Tos/Calc: IMSUM function|IMSUM]], [[Documentation/How_Tos/Calc: INDEX function|INDEX]], [[Documentation/How_Tos/Calc: INDIRECT function|INDIRECT]], [[Documentation/How_Tos/Calc: INFO function|INFO]], [[Documentation/How_Tos/Calc: INT function|INT]], [[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]], [[Documentation/How_Tos/Calc: INTRATE function|INTRATE]], [[Documentation/How_Tos/Calc: IPMT function|IPMT]], [[Documentation/How_Tos/Calc: IRR function|IRR]], [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]], [[Documentation/How_Tos/Calc: ISERR function|ISERR]], [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISEVEN_ADD function|ISEVEN_ADD]], [[Documentation/How_Tos/Calc: ISFORMULA function|ISFORMULA]], [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ISLEAPYEAR]], [[Documentation/How_Tos/Calc: ISLOGICAL function|ISLOGICAL]], [[Documentation/How_Tos/Calc: ISNA function|ISNA]], [[Documentation/How_Tos/Calc: ISNONTEXT function|ISNONTEXT]], [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: ISODD_ADD function|ISODD_ADD]], [[Documentation/How_Tos/Calc: ISPMT function|ISPMT]], [[Documentation/How_Tos/Calc: ISREF function|ISREF]], [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]] | + | *[[Documentation/How_Tos/Calc: IF function|IF]], [[Documentation/How_Tos/Calc: IMABS function|IMABS]], [[Documentation/How_Tos/Calc: IMAGINARY function|IMAGINARY]], [[Documentation/How_Tos/Calc: IMARGUMENT function|IMARGUMENT]], [[Documentation/How_Tos/Calc: IMCONJUGATE function|IMCONJUGATE]], [[Documentation/How_Tos/Calc: IMCOS function|IMCOS]], [[Documentation/How_Tos/Calc: IMCOSH function|IMCOSH]], [[Documentation/How_Tos/Calc: IMCSC function|IMCSC]], [[Documentation/How_Tos/Calc: IMCSCH function|IMCSCH]], [[Documentation/How_Tos/Calc: IMCOT function|IMCOT]], [[Documentation/How_Tos/Calc: IMDIV function|IMDIV]], [[Documentation/How_Tos/Calc: IMEXP function|IMEXP]], [[Documentation/How_Tos/Calc: IMLN function|IMLN]], [[Documentation/How_Tos/Calc: IMLOG10 function|IMLOG10]], [[Documentation/How_Tos/Calc: IMLOG2 function|IMLOG2]], [[Documentation/How_Tos/Calc: IMPOWER function|IMPOWER]], [[Documentation/How_Tos/Calc: IMPRODUCT function|IMPRODUCT]], [[Documentation/How_Tos/Calc: IMREAL function|IMREAL]], [[Documentation/How_Tos/Calc: IMSIN function|IMSIN]], [[Documentation/How_Tos/Calc: IMSINH function|IMSINH]], [[Documentation/How_Tos/Calc: IMSQRT function|IMSQRT]], [[Documentation/How_Tos/Calc: IMSUB function|IMSUB]], [[Documentation/How_Tos/Calc: IMSUM function|IMSUM]], [[Documentation/How_Tos/Calc: IMTAN function|IMTAN]], [[Documentation/How_Tos/Calc: INDEX function|INDEX]], [[Documentation/How_Tos/Calc: INDIRECT function|INDIRECT]], [[Documentation/How_Tos/Calc: INFO function|INFO]], [[Documentation/How_Tos/Calc: INT function|INT]], [[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]], [[Documentation/How_Tos/Calc: INTRATE function|INTRATE]], [[Documentation/How_Tos/Calc: IPMT function|IPMT]], [[Documentation/How_Tos/Calc: IRR function|IRR]], [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]], [[Documentation/How_Tos/Calc: ISERR function|ISERR]], [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISEVEN_ADD function|ISEVEN_ADD]], [[Documentation/How_Tos/Calc: ISFORMULA function|ISFORMULA]], [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ISLEAPYEAR]], [[Documentation/How_Tos/Calc: ISLOGICAL function|ISLOGICAL]], [[Documentation/How_Tos/Calc: ISNA function|ISNA]], [[Documentation/How_Tos/Calc: ISNONTEXT function|ISNONTEXT]], [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: ISODD_ADD function|ISODD_ADD]], [[Documentation/How_Tos/Calc: ISPMT function|ISPMT]], [[Documentation/How_Tos/Calc: ISREF function|ISREF]], [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]] |
*[[Documentation/How_Tos/Calc: KURT function|KURT]] | *[[Documentation/How_Tos/Calc: KURT function|KURT]] |
Revision as of 19:29, 9 June 2012
- 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
- IF, IMABS, IMAGINARY, IMARGUMENT, IMCONJUGATE, IMCOS, IMCOSH, IMCSC, IMCSCH, IMCOT, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, 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
- 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