Difference between revisions of "FR/Documentation/Calc/Fonctions listees par categories"
From Apache OpenOffice Wiki
< FR | Documentation | Calc
m |
|||
Line 33: | Line 33: | ||
'''[[Documentation/How_Tos/Calc: Mathematical functions|Fonctions mathématiques]]''' | '''[[Documentation/How_Tos/Calc: Mathematical functions|Fonctions mathématiques]]''' | ||
− | : | + | :Les fonctions mathématiques incluent les fonctions trigonométriques, hyperboliques, logarithmique et les fonctions de sommes. |
:[[Documentation/How_Tos/Calc: COS function|COS]], [[Documentation/How_Tos/Calc: SIN function|SIN]], [[Documentation/How_Tos/Calc: TAN function|TAN]], [[Documentation/How_Tos/Calc: COT function|COT]], [[Documentation/How_Tos/Calc: ACOS function|ACOS]], [[Documentation/How_Tos/Calc: ACOT function|ACOT]], [[Documentation/How_Tos/Calc: ASIN function|ASIN]], [[Documentation/How_Tos/Calc: ATAN function|ATAN]], [[Documentation/How_Tos/Calc: ATAN2 function|ATAN2]], [[Documentation/How_Tos/Calc: DEGREES function|DEGREES]], [[Documentation/How_Tos/Calc: RADIANS function|RADIANS]], [[Documentation/How_Tos/Calc: PI function|PI]] | :[[Documentation/How_Tos/Calc: COS function|COS]], [[Documentation/How_Tos/Calc: SIN function|SIN]], [[Documentation/How_Tos/Calc: TAN function|TAN]], [[Documentation/How_Tos/Calc: COT function|COT]], [[Documentation/How_Tos/Calc: ACOS function|ACOS]], [[Documentation/How_Tos/Calc: ACOT function|ACOT]], [[Documentation/How_Tos/Calc: ASIN function|ASIN]], [[Documentation/How_Tos/Calc: ATAN function|ATAN]], [[Documentation/How_Tos/Calc: ATAN2 function|ATAN2]], [[Documentation/How_Tos/Calc: DEGREES function|DEGREES]], [[Documentation/How_Tos/Calc: RADIANS function|RADIANS]], [[Documentation/How_Tos/Calc: PI function|PI]] | ||
:[[Documentation/How_Tos/Calc: COSH function|COSH]], [[Documentation/How_Tos/Calc: SINH function|SINH]], [[Documentation/How_Tos/Calc: TANH function|TANH]], [[Documentation/How_Tos/Calc: COTH function|COTH]], [[Documentation/How_Tos/Calc: ACOSH function|ACOSH]], [[Documentation/How_Tos/Calc: ACOTH function|ACOTH]], [[Documentation/How_Tos/Calc: ASINH function|ASINH]], [[Documentation/How_Tos/Calc: ATANH function|ATANH]] | :[[Documentation/How_Tos/Calc: COSH function|COSH]], [[Documentation/How_Tos/Calc: SINH function|SINH]], [[Documentation/How_Tos/Calc: TANH function|TANH]], [[Documentation/How_Tos/Calc: COTH function|COTH]], [[Documentation/How_Tos/Calc: ACOSH function|ACOSH]], [[Documentation/How_Tos/Calc: ACOTH function|ACOTH]], [[Documentation/How_Tos/Calc: ASINH function|ASINH]], [[Documentation/How_Tos/Calc: ATANH function|ATANH]] | ||
− | :[[Documentation/How_Tos/Calc: TRUNC function| | + | :[[Documentation/How_Tos/Calc: TRUNC function|TRONQUE]], [[Documentation/How_Tos/Calc: ROUND function|ARRONDI]], [[Documentation/How_Tos/Calc: ROUNDDOWN function|ARRONDI.INF]], [[Documentation/How_Tos/Calc: ROUNDUP function|ARRONDI.SUP]], [[Documentation/How_Tos/Calc: CEILING function|PLAFOND]], [[Documentation/How_Tos/Calc: FLOOR function|PLANCHER]], [[Documentation/How_Tos/Calc: EVEN function|PAIR]], [[Documentation/How_Tos/Calc: ODD function|IMPAIR]], [[Documentation/How_Tos/Calc: MROUND function|ARRONDI.AU.MULTIPLE]], [[Documentation/How_Tos/Calc: INT function|ENT]], [[Documentation/How_Tos/Calc: QUOTIENT function|QUOTIENT]], [[Documentation/How_Tos/Calc: MOD function|MOD]] |
:[[Documentation/How_Tos/Calc: EXP function|EXP]], [[Documentation/How_Tos/Calc: POWER function|POWER]], [[Documentation/How_Tos/Calc: LOG function|LOG]], [[Documentation/How_Tos/Calc: LN function|LN]], [[Documentation/How_Tos/Calc: LOG10 function|LOG10]] | :[[Documentation/How_Tos/Calc: EXP function|EXP]], [[Documentation/How_Tos/Calc: POWER function|POWER]], [[Documentation/How_Tos/Calc: LOG function|LOG]], [[Documentation/How_Tos/Calc: LN function|LN]], [[Documentation/How_Tos/Calc: LOG10 function|LOG10]] | ||
:[[Documentation/How_Tos/Calc: ABS function|ABS]], [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]], [[Documentation/How_Tos/Calc: COMBINA function|COMBINA]], [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]], [[Documentation/How_Tos/Calc: CONVERT_ADD function|CONVERT_ADD]], [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]], [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]], [[Documentation/How_Tos/Calc: DELTA function|DELTA]], [[Documentation/How_Tos/Calc: ERF function|ERF]], [[Documentation/How_Tos/Calc: ERFC function|ERFC]], [[Documentation/How_Tos/Calc: FACT function|FACT]], [[Documentation/How_Tos/Calc: FACTDOUBLE function|FACTDOUBLE]], [[Documentation/How_Tos/Calc: GCD function|GCD]], [[Documentation/How_Tos/Calc: GCD_ADD function|GCD_ADD]], [[Documentation/How_Tos/Calc: GESTEP function|GESTEP]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: LCM function|LCM]], [[Documentation/How_Tos/Calc: LCM_ADD function|LCM_ADD]], [[Documentation/How_Tos/Calc: MULTINOMIAL function|MULTINOMIAL]], [[Documentation/How_Tos/Calc: PRODUCT function|PRODUCT]], [[Documentation/How_Tos/Calc: RAND function|RAND]], [[Documentation/How_Tos/Calc: RANDBETWEEN function|RANDBETWEEN]], [[Documentation/How_Tos/Calc: SERIESSUM function|SERIESSUM]], [[Documentation/How_Tos/Calc: SIGN function|SIGN]], [[Documentation/How_Tos/Calc: SQRT function|SQRT]], [[Documentation/How_Tos/Calc: SQRTPI function|SQRTPI]], [[Documentation/How_Tos/Calc: SUBTOTAL function|SUBTOTAL]], [[Documentation/How_Tos/Calc: SUM function|SUM]], [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]], [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]] | :[[Documentation/How_Tos/Calc: ABS function|ABS]], [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]], [[Documentation/How_Tos/Calc: COMBINA function|COMBINA]], [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]], [[Documentation/How_Tos/Calc: CONVERT_ADD function|CONVERT_ADD]], [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]], [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]], [[Documentation/How_Tos/Calc: DELTA function|DELTA]], [[Documentation/How_Tos/Calc: ERF function|ERF]], [[Documentation/How_Tos/Calc: ERFC function|ERFC]], [[Documentation/How_Tos/Calc: FACT function|FACT]], [[Documentation/How_Tos/Calc: FACTDOUBLE function|FACTDOUBLE]], [[Documentation/How_Tos/Calc: GCD function|GCD]], [[Documentation/How_Tos/Calc: GCD_ADD function|GCD_ADD]], [[Documentation/How_Tos/Calc: GESTEP function|GESTEP]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: LCM function|LCM]], [[Documentation/How_Tos/Calc: LCM_ADD function|LCM_ADD]], [[Documentation/How_Tos/Calc: MULTINOMIAL function|MULTINOMIAL]], [[Documentation/How_Tos/Calc: PRODUCT function|PRODUCT]], [[Documentation/How_Tos/Calc: RAND function|RAND]], [[Documentation/How_Tos/Calc: RANDBETWEEN function|RANDBETWEEN]], [[Documentation/How_Tos/Calc: SERIESSUM function|SERIESSUM]], [[Documentation/How_Tos/Calc: SIGN function|SIGN]], [[Documentation/How_Tos/Calc: SQRT function|SQRT]], [[Documentation/How_Tos/Calc: SQRTPI function|SQRTPI]], [[Documentation/How_Tos/Calc: SUBTOTAL function|SUBTOTAL]], [[Documentation/How_Tos/Calc: SUM function|SUM]], [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]], [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]] |
Revision as of 16:14, 27 April 2008
Fonctions Calc listées par catégorie
Ces pages sont une réécriture complète de l'aide pour les Fonctions de Calc. Toutes les fonctions ne sont pas incluses actuellement. Le but de cette description est d'être plus précise, plus complète et cohérente qu'avant.
Vous pouvez
- naviguer directement jusqu'aux fonction à partir de cette page, ou
- sélectionner une catégorie de fonction pour avoir une description d'une ligne sur chaque fonction et des notes explicatives sur la catégorie.
- Les fonctions Nombre complexe opèrent sur des nombres complexes (mathématique tels que 2 + 3i.
- COMPLEXE, COMPLEXE.MODULE, COMPLEXE.IMAGINAIRE, COMPLEXE.PUISSANCE, COMPLEXE.ARGUMENT, COMPLEXE.COS, COMPLEXE.DIV, COMPLEXE.EXP, COMPLEXE.CONJUGUE, COMPLEXE.LN, COMPLEXE.LOG10, COMPLEXE.LOG2, COMPLEXE.PRODUIT, COMPLEXE.REEL, COMPLEXE.SIN, COMPLEXE.DIFFERENCE, COMPLEXE.SOMME, COMPLEXE.RACINE
- Les fonctions de base de données sont utilisées pour extraire des informations de tables de données Calc, dans lesquelles les données sont organisées en lignes.
- BDNB, BDNBVAL, BDLIRE, BDMAX, BDMIN, BDMOYENNE, BDPRODUIT, BDECARTYPE, BDECARTYPEP, BDSOMME, BDVAR, BDVARP
- Les fonctions de date et d'heure sont utilisées pour manipuler des heures et des dates.
- AUJOURDHUI, MAINTENANT, ANNEE, MOIS, JOUR, JOURSEM, HEURE, MINUTE, SECONDE, DATE, DATEVAL, TEMPS, TEMPSVAL, FIN.MOIS, MOIS.DECALER, SERIE.JOUR.OUVRE, NB.JOURS.OUVRES, JOURS, JOURS360, JOURSDANSMOIS, JOURSDANSANNEE, SEMAINES, SEMAINESDANSANNEE, NO.SEMAINE, NO.SEMAINE_ADD, NB.MOIS, ANNEES, ESTBISSEXTILE, DIMANCHEDEPAQUES, FRACTIONANNEE
- Les fonctions financières fournissent des calculs courrants dans le monde de la finance.
- Les fonctions d'information renvoient des informations à propos de la cellule, par exemple si elles contiennent du texte ou une formule, etc.
- CELLULE, ACTUELLE, FORMULE, ESTVIDE, ESTERR, ESTERREUR, EST.PAIR, ISEVEN_ADD, ESTFORMULE, ESTLOGIQUE, ESTNA, ESTNONTEXTE, ESTNUM, EST.IMPAIR, EST.IMPAIR_ADD, ESTREF, ESTTEXTE, N, NA, TYPE
- Les fonctions logiques incluent les fonctions logiques booléennes ET, OU, NON et des fonctions telles que SI qui teste un résultat logique.
- ET, FAUX, SI, NON, OU, VRAI
- Les fonctions mathématiques incluent les fonctions trigonométriques, hyperboliques, logarithmique et les fonctions de sommes.
- COS, SIN, TAN, COT, ACOS, ACOT, ASIN, ATAN, ATAN2, DEGREES, RADIANS, PI
- COSH, SINH, TANH, COTH, ACOSH, ACOTH, ASINH, ATANH
- TRONQUE, ARRONDI, ARRONDI.INF, ARRONDI.SUP, PLAFOND, PLANCHER, PAIR, IMPAIR, ARRONDI.AU.MULTIPLE, ENT, 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 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 Statistical functions provide statistical and probability calculations.
- AVEDEV AVERAGE AVERAGEA B BETADIST BETAINV BINOMDIST COUNT COUNTA CHIINV CHITEST CHIDIST CONFIDENCE CORREL COVAR CRITBINOM DEVSQ EXPONDIST FINV FISHER FISHERINV FDIST FORECAST FTEST GAMMAINV GAMMALN GAMMADIST GAUSS GEOMEAN HARMEAN HYPGEOMDIST INTERCEPT KURT LARGE LOGINV LOGNORMDIST MAX MAXA MEDIAN MIN MINA MODE NEGBINOMDIST NORMINV NORMDIST NORMSINV NORMSDIST PEARSON PERCENTILE PERCENTRANK PERMUT PERMUTATIONA PHI POISSON PROB QUARTILE RANK RSQ SKEW SLOPE SMALL STANDARDIZE STDEV STDEVA STDEVP STDEVPA STEYX TDIST TINV TRIMMEAN TTEST VAR VARA VARP VARPA WEIBULL ZTEST