Difference between revisions of "FR/Documentation/Calc/Fonctions listees par categories"

From Apache OpenOffice Wiki
< FR‎ | Documentation‎ | Calc
Jump to: navigation, search
m
m
Line 18: Line 18:
 
'''[[Documentation/How_Tos/Calc: Date & Time functions|Fonctions de date et d'heure]]'''
 
'''[[Documentation/How_Tos/Calc: Date & Time functions|Fonctions de date et d'heure]]'''
 
:Les fonctions de date et d'heure sont utilisées pour manipuler des heures et des dates.
 
:Les fonctions de date et d'heure sont utilisées pour manipuler des heures et des dates.
:[[Documentation/How_Tos/Calc: TODAY  function|AUJOURDHUI]], [[Documentation/How_Tos/Calc: NOW function|MAINTENANT]], [[Documentation/How_Tos/Calc: YEAR function|ANNEE]], [[Documentation/How_Tos/Calc: MONTH function|MOIS]], [[Documentation/How_Tos/Calc: DAY function|JOUR]], [[Documentation/How_Tos/Calc: WEEKDAY function|JOURSEM]], [[Documentation/How_Tos/Calc: HOUR function|HEURE]], [[Documentation/How_Tos/Calc: MINUTE function|MINUTE]], [[Documentation/How_Tos/Calc: SECOND function|SECONDE]], [[Documentation/How_Tos/Calc: DATE function|DATE]], [[Documentation/How_Tos/Calc: DATEVALUE function|DATEVAL]], [[Documentation/How_Tos/Calc: TIME function|TIME]], [[Documentation/How_Tos/Calc: TIMEVALUE function|TIMEVALUE]], [[Documentation/How_Tos/Calc: EOMONTH function|EOMONTH]], [[Documentation/How_Tos/Calc: EDATE function|EDATE]], [[Documentation/How_Tos/Calc: WORKDAY function|WORKDAY]], [[Documentation/How_Tos/Calc: NETWORKDAYS function|NETWORKDAYS]], [[Documentation/How_Tos/Calc: DAYS function|DAYS]], [[Documentation/How_Tos/Calc: DAYS360 function|DAYS360]], [[Documentation/How_Tos/Calc: DAYSINMONTH function|DAYSINMONTH]], [[Documentation/How_Tos/Calc: DAYSINYEAR function|JOURSDANSANNEE]], [[Documentation/How_Tos/Calc: WEEKS function|WEEKS]], [[Documentation/How_Tos/Calc: WEEKSINYEAR function|SEMAINESDANSANNEE]], [[Documentation/How_Tos/Calc: WEEKNUM function|WEEKNUM]], [[Documentation/How_Tos/Calc: WEEKNUM_ADD function|WEEKNUM_ADD]], [[Documentation/How_Tos/Calc: MONTHS function|MONTHS]], [[Documentation/How_Tos/Calc: YEARS function|ANNEES]], [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ESTBISSEXTILE]], [[Documentation/How_Tos/Calc: EASTERSUNDAY function|EASTERSUNDAY]], [[Documentation/How_Tos/Calc: YEARFRAC function|FRACTIONANNEE]]
+
:[[Documentation/How_Tos/Calc: TODAY  function|AUJOURDHUI]], [[Documentation/How_Tos/Calc: NOW function|MAINTENANT]], [[Documentation/How_Tos/Calc: YEAR function|ANNEE]], [[Documentation/How_Tos/Calc: MONTH function|MOIS]], [[Documentation/How_Tos/Calc: DAY function|JOUR]], [[Documentation/How_Tos/Calc: WEEKDAY function|JOURSEM]], [[Documentation/How_Tos/Calc: HOUR function|HEURE]], [[Documentation/How_Tos/Calc: MINUTE function|MINUTE]], [[Documentation/How_Tos/Calc: SECOND function|SECONDE]], [[Documentation/How_Tos/Calc: DATE function|DATE]], [[Documentation/How_Tos/Calc: DATEVALUE function|DATEVAL]], [[Documentation/How_Tos/Calc: TIME function|TEMPS]], [[Documentation/How_Tos/Calc: TIMEVALUE function|TEMPSVAL]], [[Documentation/How_Tos/Calc: EOMONTH function|FIN.MOIS]], [[Documentation/How_Tos/Calc: EDATE function|MOIS.DECALER]], [[Documentation/How_Tos/Calc: WORKDAY function|SERIE.JOUR.OUVRE]], [[Documentation/How_Tos/Calc: NETWORKDAYS function|NB.JOURS.OUVRES]], [[Documentation/How_Tos/Calc: DAYS function|JOURS]], [[Documentation/How_Tos/Calc: DAYS360 function|JOURS360]], [[Documentation/How_Tos/Calc: DAYSINMONTH function|JOURSDANSMOIS]], [[Documentation/How_Tos/Calc: DAYSINYEAR function|JOURSDANSANNEE]], [[Documentation/How_Tos/Calc: WEEKS function|SEMAINES]], [[Documentation/How_Tos/Calc: WEEKSINYEAR function|SEMAINESDANSANNEE]], [[Documentation/How_Tos/Calc: WEEKNUM function|NO.SEMAINE]], [[Documentation/How_Tos/Calc: WEEKNUM_ADD function|NO.SEMAINE_ADD]], [[Documentation/How_Tos/Calc: MONTHS function|NB.MOIS]], [[Documentation/How_Tos/Calc: YEARS function|ANNEES]], [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ESTBISSEXTILE]], [[Documentation/How_Tos/Calc: EASTERSUNDAY function|DIMANCHEDEPAQUES]], [[Documentation/How_Tos/Calc: YEARFRAC function|FRACTIONANNEE]]
  
 
'''[[Documentation/How_Tos/Calc: Financial functions|Financial functions]]'''
 
'''[[Documentation/How_Tos/Calc: Financial functions|Financial functions]]'''

Revision as of 15:43, 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.

Fonctions de nombre complexe

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

Fonctions de base de données

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

Fonctions de date et d'heure

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

Financial functions

The Financial functions provide common business calculations.

Information functions

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

Logical functions

The Logical functions include boolean logic AND, OR, NOT functions, and functions such as IF which test a logical result.
AND, FALSE, IF, NOT, OR, TRUE

Mathematical functions

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

Number Conversion functions

The Number Conversion functions convert numbers between forms.
BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
ARABIC, BAHTTEXT, DECIMAL, ROMAN

Array functions

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

Statistical functions

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

Spreadsheet functions

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

Text functions

The Text functions manipulate or return text.
BASE, CHAR, CLEAN, CODE, CONCATENATE, DOLLAR, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TRIM, UPPER, VALUE
Personal tools