User:Pasc92/Books/Calc Functions (PE)

Calc Functions

Les fonctions du tableur OOo

Documentation/How Tos/Calc: Functions listed by category

Documentation/How Tos/Calc: Functions listed alphabetically

Documentation/How Tos/Calc: ABS function

Documentation/How Tos/Calc: ACCRINT function

Documentation/How Tos/Calc: ACCRINTM function

Documentation/How Tos/Calc: ACOS function

Documentation/How Tos/Calc: ACOSH function

Documentation/How Tos/Calc: ACOT function

Documentation/How Tos/Calc: ACOTH function

Documentation/How Tos/Calc: ADDRESS function

Documentation/How Tos/Calc: AMORDEGRC function

Documentation/How Tos/Calc: AMORLINC function

Documentation/How Tos/Calc: AND function

Documentation/How Tos/Calc: ARABIC function

Documentation/How Tos/Calc: AREAS function

Documentation/How Tos/Calc: ASIN function

Documentation/How Tos/Calc: ASINH function

Documentation/How Tos/Calc: ATAN function

Documentation/How Tos/Calc: ATAN2 function

Documentation/How Tos/Calc: ATANH function

Documentation/How Tos/Calc: AVEDEV function

Documentation/How Tos/Calc: AVERAGE function

Documentation/How Tos/Calc: AVERAGEA function

Documentation/How Tos/Calc: B function

Documentation/How Tos/Calc: BAHTTEXT function

Documentation/How Tos/Calc: BASE function

Documentation/How Tos/Calc: BESSELI function

Documentation/How Tos/Calc: BESSELJ function

Documentation/How Tos/Calc: BESSELK function

Documentation/How Tos/Calc: BESSELY function

Documentation/How Tos/Calc: BETADIST function

Documentation/How Tos/Calc: BETAINV function

Documentation/How Tos/Calc: BIN2DEC function

Documentation/How Tos/Calc: BIN2HEX function

Documentation/How Tos/Calc: BIN2OCT function

Documentation/How Tos/Calc: BINOMDIST function

Documentation/How Tos/Calc: CEILING function

Documentation/How Tos/Calc: CELL function

Documentation/How Tos/Calc: CHAR function

Documentation/How Tos/Calc: CHIDIST function

Documentation/How Tos/Calc: CHIINV function

Documentation/How Tos/Calc: CHISQDIST function

Documentation/How Tos/Calc: CHISQINV function

Documentation/How Tos/Calc: CHITEST function

Documentation/How Tos/Calc: CHOOSE function

Documentation/How Tos/Calc: CLEAN function

Documentation/How Tos/Calc: CODE function

Documentation/How Tos/Calc: COLUMN function

Documentation/How Tos/Calc: COLUMNS function

Documentation/How Tos/Calc: COMBIN function

Documentation/How Tos/Calc: COMBINA function

Documentation/How Tos/Calc: COMPLEX function

Documentation/How Tos/Calc: CONCATENATE function

Documentation/How Tos/Calc: CONFIDENCE function

Documentation/How Tos/Calc: CONVERT function

Documentation/How Tos/Calc: CONVERT ADD function

Documentation/How Tos/Calc: CORREL function

Documentation/How Tos/Calc: COS function

Documentation/How Tos/Calc: COSH function

Documentation/How Tos/Calc: COT function

Documentation/How Tos/Calc: COTH function

Documentation/How Tos/Calc: COUNT function

Documentation/How Tos/Calc: COUNTA function

Documentation/How Tos/Calc: COUNTBLANK function

Documentation/How Tos/Calc: COUNTIF function

Documentation/How Tos/Calc: COUPDAYBS function

Documentation/How Tos/Calc: COUPDAYS function

Documentation/How Tos/Calc: COUPDAYSNC function

Documentation/How Tos/Calc: COUPNCD function

Documentation/How Tos/Calc: COUPNUM function

Documentation/How Tos/Calc: COUPPCD function

Documentation/How Tos/Calc: COVAR function

Documentation/How Tos/Calc: CRITBINOM function

Documentation/How Tos/Calc: CUMIPMT function

Documentation/How Tos/Calc: CUMIPMT ADD function

Documentation/How Tos/Calc: CUMPRINC function

Documentation/How Tos/Calc: CUMPRINC ADD function

Documentation/How Tos/Calc: CURRENT function

Documentation/How Tos/Calc: DATE function

Documentation/How Tos/Calc: DATEVALUE function

Documentation/How Tos/Calc: DAVERAGE function

Documentation/How Tos/Calc: DAY function

Documentation/How Tos/Calc: DAYS function

Documentation/How Tos/Calc: DAYS360 function

Documentation/How Tos/Calc: DAYSINMONTH function

Documentation/How Tos/Calc: DAYSINYEAR function

Documentation/How Tos/Calc: DB function

Documentation/How Tos/Calc: DCOUNT function

Documentation/How Tos/Calc: DCOUNTA function

Documentation/How Tos/Calc: DDB function

Documentation/How Tos/Calc: DDE function

Documentation/How Tos/Calc: DEC2BIN function

Documentation/How Tos/Calc: DEC2HEX function

Documentation/How Tos/Calc: DEC2OCT function

Documentation/How Tos/Calc: DECIMAL function

Documentation/How Tos/Calc: DEGREES function

Documentation/How Tos/Calc: DELTA function

Documentation/How Tos/Calc: DEVSQ function

Documentation/How Tos/Calc: DGET function

Documentation/How Tos/Calc: DISC function

Documentation/How Tos/Calc: DMAX function

Documentation/How Tos/Calc: DMIN function

Documentation/How Tos/Calc: DOLLAR function

Documentation/How Tos/Calc: DOLLARDE function

Documentation/How Tos/Calc: DOLLARFR function

Documentation/How Tos/Calc: DPRODUCT function

Documentation/How Tos/Calc: DSTDEV function

Documentation/How Tos/Calc: DSTDEVP function

Documentation/How Tos/Calc: DSUM function

Documentation/How Tos/Calc: DURATION function

Documentation/How Tos/Calc: DURATION ADD function

Documentation/How Tos/Calc: DVAR function

Documentation/How Tos/Calc: DVARP function

Documentation/How Tos/Calc: EASTERSUNDAY function

Documentation/How Tos/Calc: EDATE function

Documentation/How Tos/Calc: EFFECT ADD function

Documentation/How Tos/Calc: EFFECTIVE function

Documentation/How Tos/Calc: EOMONTH function

Documentation/How Tos/Calc: ERF function

Documentation/How Tos/Calc: ERFC function

Documentation/How Tos/Calc: ERRORTYPE function

Documentation/How Tos/Calc: EVEN function

Documentation/How Tos/Calc: EXACT function

Documentation/How Tos/Calc: EXP function

Documentation/How Tos/Calc: EXPONDIST function

Documentation/How Tos/Calc: FACT function

Documentation/How Tos/Calc: FACTDOUBLE function

Documentation/How Tos/Calc: FALSE function

Documentation/How Tos/Calc: FDIST function

Documentation/How Tos/Calc: FIND function

Documentation/How Tos/Calc: FINV function

Documentation/How Tos/Calc: FISHER function

Documentation/How Tos/Calc: FISHERINV function

Documentation/How Tos/Calc: FIXED function

Documentation/How Tos/Calc: FLOOR function

Documentation/How Tos/Calc: FORECAST function

Documentation/How Tos/Calc: FORMULA function

Documentation/How Tos/Calc: FREQUENCY function

Documentation/How Tos/Calc: FTEST function

Documentation/How Tos/Calc: FV function

Documentation/How Tos/Calc: FVSCHEDULE function

Documentation/How Tos/Calc: GAMMA function

Documentation/How Tos/Calc: GAMMADIST function

Documentation/How Tos/Calc: GAMMAINV function

Documentation/How Tos/Calc: GAMMALN function

Documentation/How Tos/Calc: GAUSS function

Documentation/How Tos/Calc: GCD function

Documentation/How Tos/Calc: GCD ADD function

Documentation/How Tos/Calc: GEOMEAN function

Documentation/How Tos/Calc: GESTEP function

Documentation/How Tos/Calc: GROWTH function

Documentation/How Tos/Calc: HARMEAN function

Documentation/How Tos/Calc: HEX2BIN function

Documentation/How Tos/Calc: HEX2DEC function

Documentation/How Tos/Calc: HEX2OCT function

Documentation/How Tos/Calc: HLOOKUP function

Documentation/How Tos/Calc: HOUR function

Documentation/How Tos/Calc: HYPERLINK function

Documentation/How Tos/Calc: HYPGEOMDIST function

Documentation/How Tos/Calc: IF function

Documentation/How Tos/Calc: IMABS function

Documentation/How Tos/Calc: IMAGINARY function

Documentation/How Tos/Calc: IMARGUMENT function

Documentation/How Tos/Calc: IMCONJUGATE function

Documentation/How Tos/Calc: IMCOS function

Documentation/How Tos/Calc: IMDIV function

Documentation/How Tos/Calc: IMEXP function

Documentation/How Tos/Calc: IMLN function

Documentation/How Tos/Calc: IMLOG10 function

Documentation/How Tos/Calc: IMLOG2 function

Documentation/How Tos/Calc: IMPOWER function

Documentation/How Tos/Calc: IMPRODUCT function

Documentation/How Tos/Calc: IMREAL function

Documentation/How Tos/Calc: IMSIN function

Documentation/How Tos/Calc: IMSQRT function

Documentation/How Tos/Calc: IMSUB function

Documentation/How Tos/Calc: IMSUM function

Documentation/How Tos/Calc: INDEX function

Documentation/How Tos/Calc: INDIRECT function

Documentation/How Tos/Calc: INFO function

Documentation/How Tos/Calc: INT function

Documentation/How Tos/Calc: INTERCEPT function

Documentation/How Tos/Calc: INTRATE function

Documentation/How Tos/Calc: IPMT function

Documentation/How Tos/Calc: IRR function

Documentation/How Tos/Calc: ISBLANK function

Documentation/How Tos/Calc: ISERR function

Documentation/How Tos/Calc: ISERROR function

Documentation/How Tos/Calc: ISEVEN function

Documentation/How Tos/Calc: ISEVEN ADD function

Documentation/How Tos/Calc: ISFORMULA function

Documentation/How Tos/Calc: ISLEAPYEAR function

Documentation/How Tos/Calc: ISLOGICAL function

Documentation/How Tos/Calc: ISNA function

Documentation/How Tos/Calc: ISNONTEXT function

Documentation/How Tos/Calc: ISNUMBER function

Documentation/How Tos/Calc: ISODD function

Documentation/How Tos/Calc: ISODD ADD function

Documentation/How Tos/Calc: ISPMT function

Documentation/How Tos/Calc: ISREF function

Documentation/How Tos/Calc: ISTEXT function

Documentation/How Tos/Calc: KURT function

Documentation/How Tos/Calc: LARGE function

Documentation/How Tos/Calc: LCM function

Documentation/How Tos/Calc: LCM ADD function

Documentation/How Tos/Calc: LEFT function

Documentation/How Tos/Calc: LEN function

Documentation/How Tos/Calc: LINEST function

Documentation/How Tos/Calc: LN function

Documentation/How Tos/Calc: LOG function

Documentation/How Tos/Calc: LOG10 function

Documentation/How Tos/Calc: LOGEST function

Documentation/How Tos/Calc: LOGINV function

Documentation/How Tos/Calc: LOGNORMDIST function

Documentation/How Tos/Calc: LOOKUP function

Documentation/How Tos/Calc: LOWER function

Documentation/How Tos/Calc: MATCH function

Documentation/How Tos/Calc: MAX function

Documentation/How Tos/Calc: MAXA function

Documentation/How Tos/Calc: MDETERM function

Documentation/How Tos/Calc: MDURATION function

Documentation/How Tos/Calc: MEDIAN function

Documentation/How Tos/Calc: MID function

Documentation/How Tos/Calc: MIN function

Documentation/How Tos/Calc: MINA function

Documentation/How Tos/Calc: MINUTE function

Documentation/How Tos/Calc: MINVERSE function

Documentation/How Tos/Calc: MIRR function

Documentation/How Tos/Calc: MMULT function

Documentation/How Tos/Calc: MOD function

Documentation/How Tos/Calc: MODE function

Documentation/How Tos/Calc: MONTH function

Documentation/How Tos/Calc: MONTHS function

Documentation/How Tos/Calc: MROUND function

Documentation/How Tos/Calc: MULTINOMIAL function

Documentation/How Tos/Calc: MUNIT function

Documentation/How Tos/Calc: N function

Documentation/How Tos/Calc: NA function

Documentation/How Tos/Calc: NEGBINOMDIST function

Documentation/How Tos/Calc: NETWORKDAYS function

Documentation/How Tos/Calc: NOMINAL function

Documentation/How Tos/Calc: NOMINAL ADD function

Documentation/How Tos/Calc: NORMDIST function

Documentation/How Tos/Calc: NORMINV function

Documentation/How Tos/Calc: NORMSDIST function

Documentation/How Tos/Calc: NORMSINV function

Documentation/How Tos/Calc: NOT function

Documentation/How Tos/Calc: NOW function

Documentation/How Tos/Calc: NPER function

Documentation/How Tos/Calc: NPV function

Documentation/How Tos/Calc: OCT2BIN function

Documentation/How Tos/Calc: OCT2DEC function

Documentation/How Tos/Calc: OCT2HEX function

Documentation/How Tos/Calc: ODD function

Documentation/How Tos/Calc: ODDFPRICE function

Documentation/How Tos/Calc: ODDFYIELD function

Documentation/How Tos/Calc: ODDLPRICE function

Documentation/How Tos/Calc: ODDLYIELD function

Documentation/How Tos/Calc: OFFSET function

Documentation/How Tos/Calc: OR function

Documentation/How Tos/Calc: PEARSON function

Documentation/How Tos/Calc: PERCENTILE function

Documentation/How Tos/Calc: PERCENTRANK function

Documentation/How Tos/Calc: PERMUT function

Documentation/How Tos/Calc: PERMUTATIONA function

Documentation/How Tos/Calc: PHI function

Documentation/How Tos/Calc: PI function

Documentation/How Tos/Calc: PMT function

Documentation/How Tos/Calc: POISSON function

Documentation/How Tos/Calc: POWER function

Documentation/How Tos/Calc: PPMT function

Documentation/How Tos/Calc: PRICE function

Documentation/How Tos/Calc: PRICEDISC function

Documentation/How Tos/Calc: PRICEMAT function

Documentation/How Tos/Calc: PROB function

Documentation/How Tos/Calc: PRODUCT function

Documentation/How Tos/Calc: PROPER function

Documentation/How Tos/Calc: PV function

Documentation/How Tos/Calc: QUARTILE function

Documentation/How Tos/Calc: QUOTIENT function

Documentation/How Tos/Calc: RADIANS function

Documentation/How Tos/Calc: RAND function

Documentation/How Tos/Calc: RANDBETWEEN function

Documentation/How Tos/Calc: RANK function

Documentation/How Tos/Calc: RATE function

Documentation/How Tos/Calc: RECEIVED function

Documentation/How Tos/Calc: REPLACE function

Documentation/How Tos/Calc: REPT function

Documentation/How Tos/Calc: RIGHT function

Documentation/How Tos/Calc: ROMAN function

Documentation/How Tos/Calc: ROUND function

Documentation/How Tos/Calc: ROUNDDOWN function

Documentation/How Tos/Calc: ROUNDUP function

Documentation/How Tos/Calc: ROW function

Documentation/How Tos/Calc: ROWS function

Documentation/How Tos/Calc: RRI function

Documentation/How Tos/Calc: RSQ function

Documentation/How Tos/Calc: SEARCH function

Documentation/How Tos/Calc: SECOND function

Documentation/How Tos/Calc: SERIESSUM function

Documentation/How Tos/Calc: SHEET function

Documentation/How Tos/Calc: SHEETS function

Documentation/How Tos/Calc: SIGN function

Documentation/How Tos/Calc: SIN function

Documentation/How Tos/Calc: SINH function

Documentation/How Tos/Calc: SKEW function

Documentation/How Tos/Calc: SLN function

Documentation/How Tos/Calc: SLOPE function

Documentation/How Tos/Calc: SMALL function

Documentation/How Tos/Calc: SQRT function

Documentation/How Tos/Calc: SQRTPI function

Documentation/How Tos/Calc: STANDARDIZE function

Documentation/How Tos/Calc: STDEV function

Documentation/How Tos/Calc: STDEVA function

Documentation/How Tos/Calc: STDEVP function

Documentation/How Tos/Calc: STDEVPA function

Documentation/How Tos/Calc: STEYX function

Documentation/How Tos/Calc: STYLE function

Documentation/How Tos/Calc: SUBSTITUTE function

Documentation/How Tos/Calc: SUBTOTAL function

Documentation/How Tos/Calc: SUM function

Documentation/How Tos/Calc: SUMIF function

Documentation/How Tos/Calc: SUMPRODUCT function

Documentation/How Tos/Calc: SUMSQ function

Documentation/How Tos/Calc: SUMX2MY2 function

Documentation/How Tos/Calc: SUMX2PY2 function

Documentation/How Tos/Calc: SUMXMY2 function

Documentation/How Tos/Calc: SYD function

Documentation/How Tos/Calc: T function

Documentation/How Tos/Calc: TAN function

Documentation/How Tos/Calc: TANH function

Documentation/How Tos/Calc: TBILLEQ function

Documentation/How Tos/Calc: TBILLPRICE function

Documentation/How Tos/Calc: TBILLYIELD function

Documentation/How Tos/Calc: TDIST function

Documentation/How Tos/Calc: TEXT function

Documentation/How Tos/Calc: TIME function

Documentation/How Tos/Calc: TIMEVALUE function

Documentation/How Tos/Calc: TINV function

Documentation/How Tos/Calc: TODAY function

Documentation/How Tos/Calc: TRANSPOSE function

Documentation/How Tos/Calc: TREND function

Documentation/How Tos/Calc: TRIM function

Documentation/How Tos/Calc: TRIMMEAN function

Documentation/How Tos/Calc: TRUE function

Documentation/How Tos/Calc: TRUNC function

Documentation/How Tos/Calc: TTEST function

Documentation/How Tos/Calc: TYPE function

Documentation/How Tos/Calc: UPPER function

Documentation/How Tos/Calc: VALUE function

Documentation/How Tos/Calc: VAR function

Documentation/How Tos/Calc: VARA function

Documentation/How Tos/Calc: VARP function

Documentation/How Tos/Calc: VARPA function

Documentation/How Tos/Calc: VDB function

Documentation/How Tos/Calc: VLOOKUP function

Documentation/How Tos/Calc: WEEKDAY function

Documentation/How Tos/Calc: WEEKNUM function

Documentation/How Tos/Calc: WEEKNUM ADD function

Documentation/How Tos/Calc: WEEKS function

Documentation/How Tos/Calc: WEEKSINYEAR function

Documentation/How Tos/Calc: WEIBULL function

Documentation/How Tos/Calc: WORKDAY function

Documentation/How Tos/Calc: XIRR function

Documentation/How Tos/Calc: XNPV function

Documentation/How Tos/Calc: YEAR function

Documentation/How Tos/Calc: YEARFRAC function

Documentation/How Tos/Calc: YEARS function

Documentation/How Tos/Calc: YIELD function

Documentation/How Tos/Calc: YIELDDISC function

Documentation/How Tos/Calc: YIELDMAT function

Documentation/How Tos/Calc: ZTEST function