############################################################
|
##
|
## PhpSpreadsheet - function name translations
|
##
|
## Français (French)
|
##
|
############################################################
|
|
|
##
|
## Fonctions Cube (Cube Functions)
|
##
|
CUBEKPIMEMBER = MEMBREKPICUBE
|
CUBEMEMBER = MEMBRECUBE
|
CUBEMEMBERPROPERTY = PROPRIETEMEMBRECUBE
|
CUBERANKEDMEMBER = RANGMEMBRECUBE
|
CUBESET = JEUCUBE
|
CUBESETCOUNT = NBJEUCUBE
|
CUBEVALUE = VALEURCUBE
|
|
##
|
## Fonctions de base de données (Database Functions)
|
##
|
DAVERAGE = BDMOYENNE
|
DCOUNT = BDNB
|
DCOUNTA = BDNBVAL
|
DGET = BDLIRE
|
DMAX = BDMAX
|
DMIN = BDMIN
|
DPRODUCT = BDPRODUIT
|
DSTDEV = BDECARTYPE
|
DSTDEVP = BDECARTYPEP
|
DSUM = BDSOMME
|
DVAR = BDVAR
|
DVARP = BDVARP
|
|
##
|
## Fonctions de date et d’heure (Date & Time Functions)
|
##
|
DATE = DATE
|
DATEVALUE = DATEVAL
|
DAY = JOUR
|
DAYS = JOURS
|
DAYS360 = JOURS360
|
EDATE = MOIS.DECALER
|
EOMONTH = FIN.MOIS
|
HOUR = HEURE
|
ISOWEEKNUM = NO.SEMAINE.ISO
|
MINUTE = MINUTE
|
MONTH = MOIS
|
NETWORKDAYS = NB.JOURS.OUVRES
|
NETWORKDAYS.INTL = NB.JOURS.OUVRES.INTL
|
NOW = MAINTENANT
|
SECOND = SECONDE
|
TIME = TEMPS
|
TIMEVALUE = TEMPSVAL
|
TODAY = AUJOURDHUI
|
WEEKDAY = JOURSEM
|
WEEKNUM = NO.SEMAINE
|
WORKDAY = SERIE.JOUR.OUVRE
|
WORKDAY.INTL = SERIE.JOUR.OUVRE.INTL
|
YEAR = ANNEE
|
YEARFRAC = FRACTION.ANNEE
|
|
##
|
## Fonctions d’ingénierie (Engineering Functions)
|
##
|
BESSELI = BESSELI
|
BESSELJ = BESSELJ
|
BESSELK = BESSELK
|
BESSELY = BESSELY
|
BIN2DEC = BINDEC
|
BIN2HEX = BINHEX
|
BIN2OCT = BINOCT
|
BITAND = BITET
|
BITLSHIFT = BITDECALG
|
BITOR = BITOU
|
BITRSHIFT = BITDECALD
|
BITXOR = BITOUEXCLUSIF
|
COMPLEX = COMPLEXE
|
CONVERT = CONVERT
|
DEC2BIN = DECBIN
|
DEC2HEX = DECHEX
|
DEC2OCT = DECOCT
|
DELTA = DELTA
|
ERF = ERF
|
ERF.PRECISE = ERF.PRECIS
|
ERFC = ERFC
|
ERFC.PRECISE = ERFC.PRECIS
|
GESTEP = SUP.SEUIL
|
HEX2BIN = HEXBIN
|
HEX2DEC = HEXDEC
|
HEX2OCT = HEXOCT
|
IMABS = COMPLEXE.MODULE
|
IMAGINARY = COMPLEXE.IMAGINAIRE
|
IMARGUMENT = COMPLEXE.ARGUMENT
|
IMCONJUGATE = COMPLEXE.CONJUGUE
|
IMCOS = COMPLEXE.COS
|
IMCOSH = COMPLEXE.COSH
|
IMCOT = COMPLEXE.COT
|
IMCSC = COMPLEXE.CSC
|
IMCSCH = COMPLEXE.CSCH
|
IMDIV = COMPLEXE.DIV
|
IMEXP = COMPLEXE.EXP
|
IMLN = COMPLEXE.LN
|
IMLOG10 = COMPLEXE.LOG10
|
IMLOG2 = COMPLEXE.LOG2
|
IMPOWER = COMPLEXE.PUISSANCE
|
IMPRODUCT = COMPLEXE.PRODUIT
|
IMREAL = COMPLEXE.REEL
|
IMSEC = COMPLEXE.SEC
|
IMSECH = COMPLEXE.SECH
|
IMSIN = COMPLEXE.SIN
|
IMSINH = COMPLEXE.SINH
|
IMSQRT = COMPLEXE.RACINE
|
IMSUB = COMPLEXE.DIFFERENCE
|
IMSUM = COMPLEXE.SOMME
|
IMTAN = COMPLEXE.TAN
|
OCT2BIN = OCTBIN
|
OCT2DEC = OCTDEC
|
OCT2HEX = OCTHEX
|
|
##
|
## Fonctions financières (Financial Functions)
|
##
|
ACCRINT = INTERET.ACC
|
ACCRINTM = INTERET.ACC.MAT
|
AMORDEGRC = AMORDEGRC
|
AMORLINC = AMORLINC
|
COUPDAYBS = NB.JOURS.COUPON.PREC
|
COUPDAYS = NB.JOURS.COUPONS
|
COUPDAYSNC = NB.JOURS.COUPON.SUIV
|
COUPNCD = DATE.COUPON.SUIV
|
COUPNUM = NB.COUPONS
|
COUPPCD = DATE.COUPON.PREC
|
CUMIPMT = CUMUL.INTER
|
CUMPRINC = CUMUL.PRINCPER
|
DB = DB
|
DDB = DDB
|
DISC = TAUX.ESCOMPTE
|
DOLLARDE = PRIX.DEC
|
DOLLARFR = PRIX.FRAC
|
DURATION = DUREE
|
EFFECT = TAUX.EFFECTIF
|
FV = VC
|
FVSCHEDULE = VC.PAIEMENTS
|
INTRATE = TAUX.INTERET
|
IPMT = INTPER
|
IRR = TRI
|
ISPMT = ISPMT
|
MDURATION = DUREE.MODIFIEE
|
MIRR = TRIM
|
NOMINAL = TAUX.NOMINAL
|
NPER = NPM
|
NPV = VAN
|
ODDFPRICE = PRIX.PCOUPON.IRREG
|
ODDFYIELD = REND.PCOUPON.IRREG
|
ODDLPRICE = PRIX.DCOUPON.IRREG
|
ODDLYIELD = REND.DCOUPON.IRREG
|
PDURATION = PDUREE
|
PMT = VPM
|
PPMT = PRINCPER
|
PRICE = PRIX.TITRE
|
PRICEDISC = VALEUR.ENCAISSEMENT
|
PRICEMAT = PRIX.TITRE.ECHEANCE
|
PV = VA
|
RATE = TAUX
|
RECEIVED = VALEUR.NOMINALE
|
RRI = TAUX.INT.EQUIV
|
SLN = AMORLIN
|
SYD = SYD
|
TBILLEQ = TAUX.ESCOMPTE.R
|
TBILLPRICE = PRIX.BON.TRESOR
|
TBILLYIELD = RENDEMENT.BON.TRESOR
|
VDB = VDB
|
XIRR = TRI.PAIEMENTS
|
XNPV = VAN.PAIEMENTS
|
YIELD = RENDEMENT.TITRE
|
YIELDDISC = RENDEMENT.SIMPLE
|
YIELDMAT = RENDEMENT.TITRE.ECHEANCE
|
|
##
|
## Fonctions d’information (Information Functions)
|
##
|
CELL = CELLULE
|
ERROR.TYPE = TYPE.ERREUR
|
INFO = INFORMATIONS
|
ISBLANK = ESTVIDE
|
ISERR = ESTERR
|
ISERROR = ESTERREUR
|
ISEVEN = EST.PAIR
|
ISFORMULA = ESTFORMULE
|
ISLOGICAL = ESTLOGIQUE
|
ISNA = ESTNA
|
ISNONTEXT = ESTNONTEXTE
|
ISNUMBER = ESTNUM
|
ISODD = EST.IMPAIR
|
ISREF = ESTREF
|
ISTEXT = ESTTEXTE
|
N = N
|
NA = NA
|
SHEET = FEUILLE
|
SHEETS = FEUILLES
|
TYPE = TYPE
|
|
##
|
## Fonctions logiques (Logical Functions)
|
##
|
AND = ET
|
FALSE = FAUX
|
IF = SI
|
IFERROR = SIERREUR
|
IFNA = SI.NON.DISP
|
IFS = SI.CONDITIONS
|
NOT = NON
|
OR = OU
|
SWITCH = SI.MULTIPLE
|
TRUE = VRAI
|
XOR = OUX
|
|
##
|
## Fonctions de recherche et de référence (Lookup & Reference Functions)
|
##
|
ADDRESS = ADRESSE
|
AREAS = ZONES
|
CHOOSE = CHOISIR
|
COLUMN = COLONNE
|
COLUMNS = COLONNES
|
FORMULATEXT = FORMULETEXTE
|
GETPIVOTDATA = LIREDONNEESTABCROISDYNAMIQUE
|
HLOOKUP = RECHERCHEH
|
HYPERLINK = LIEN_HYPERTEXTE
|
INDEX = INDEX
|
INDIRECT = INDIRECT
|
LOOKUP = RECHERCHE
|
MATCH = EQUIV
|
OFFSET = DECALER
|
ROW = LIGNE
|
ROWS = LIGNES
|
RTD = RTD
|
TRANSPOSE = TRANSPOSE
|
VLOOKUP = RECHERCHEV
|
*RC = LC
|
|
##
|
## Fonctions mathématiques et trigonométriques (Math & Trig Functions)
|
##
|
ABS = ABS
|
ACOS = ACOS
|
ACOSH = ACOSH
|
ACOT = ACOT
|
ACOTH = ACOTH
|
AGGREGATE = AGREGAT
|
ARABIC = CHIFFRE.ARABE
|
ASIN = ASIN
|
ASINH = ASINH
|
ATAN = ATAN
|
ATAN2 = ATAN2
|
ATANH = ATANH
|
BASE = BASE
|
CEILING.MATH = PLAFOND.MATH
|
CEILING.PRECISE = PLAFOND.PRECIS
|
COMBIN = COMBIN
|
COMBINA = COMBINA
|
COS = COS
|
COSH = COSH
|
COT = COT
|
COTH = COTH
|
CSC = CSC
|
CSCH = CSCH
|
DECIMAL = DECIMAL
|
DEGREES = DEGRES
|
ECMA.CEILING = ECMA.PLAFOND
|
EVEN = PAIR
|
EXP = EXP
|
FACT = FACT
|
FACTDOUBLE = FACTDOUBLE
|
FLOOR.MATH = PLANCHER.MATH
|
FLOOR.PRECISE = PLANCHER.PRECIS
|
GCD = PGCD
|
INT = ENT
|
ISO.CEILING = ISO.PLAFOND
|
LCM = PPCM
|
LN = LN
|
LOG = LOG
|
LOG10 = LOG10
|
MDETERM = DETERMAT
|
MINVERSE = INVERSEMAT
|
MMULT = PRODUITMAT
|
MOD = MOD
|
MROUND = ARRONDI.AU.MULTIPLE
|
MULTINOMIAL = MULTINOMIALE
|
MUNIT = MATRICE.UNITAIRE
|
ODD = IMPAIR
|
PI = PI
|
POWER = PUISSANCE
|
PRODUCT = PRODUIT
|
QUOTIENT = QUOTIENT
|
RADIANS = RADIANS
|
RAND = ALEA
|
RANDBETWEEN = ALEA.ENTRE.BORNES
|
ROMAN = ROMAIN
|
ROUND = ARRONDI
|
ROUNDDOWN = ARRONDI.INF
|
ROUNDUP = ARRONDI.SUP
|
SEC = SEC
|
SECH = SECH
|
SERIESSUM = SOMME.SERIES
|
SIGN = SIGNE
|
SIN = SIN
|
SINH = SINH
|
SQRT = RACINE
|
SQRTPI = RACINE.PI
|
SUBTOTAL = SOUS.TOTAL
|
SUM = SOMME
|
SUMIF = SOMME.SI
|
SUMIFS = SOMME.SI.ENS
|
SUMPRODUCT = SOMMEPROD
|
SUMSQ = SOMME.CARRES
|
SUMX2MY2 = SOMME.X2MY2
|
SUMX2PY2 = SOMME.X2PY2
|
SUMXMY2 = SOMME.XMY2
|
TAN = TAN
|
TANH = TANH
|
TRUNC = TRONQUE
|
|
##
|
## Fonctions statistiques (Statistical Functions)
|
##
|
AVEDEV = ECART.MOYEN
|
AVERAGE = MOYENNE
|
AVERAGEA = AVERAGEA
|
AVERAGEIF = MOYENNE.SI
|
AVERAGEIFS = MOYENNE.SI.ENS
|
BETA.DIST = LOI.BETA.N
|
BETA.INV = BETA.INVERSE.N
|
BINOM.DIST = LOI.BINOMIALE.N
|
BINOM.DIST.RANGE = LOI.BINOMIALE.SERIE
|
BINOM.INV = LOI.BINOMIALE.INVERSE
|
CHISQ.DIST = LOI.KHIDEUX.N
|
CHISQ.DIST.RT = LOI.KHIDEUX.DROITE
|
CHISQ.INV = LOI.KHIDEUX.INVERSE
|
CHISQ.INV.RT = LOI.KHIDEUX.INVERSE.DROITE
|
CHISQ.TEST = CHISQ.TEST
|
CONFIDENCE.NORM = INTERVALLE.CONFIANCE.NORMAL
|
CONFIDENCE.T = INTERVALLE.CONFIANCE.STUDENT
|
CORREL = COEFFICIENT.CORRELATION
|
COUNT = NB
|
COUNTA = NBVAL
|
COUNTBLANK = NB.VIDE
|
COUNTIF = NB.SI
|
COUNTIFS = NB.SI.ENS
|
COVARIANCE.P = COVARIANCE.PEARSON
|
COVARIANCE.S = COVARIANCE.STANDARD
|
DEVSQ = SOMME.CARRES.ECARTS
|
EXPON.DIST = LOI.EXPONENTIELLE.N
|
F.DIST = LOI.F.N
|
F.DIST.RT = LOI.F.DROITE
|
F.INV = INVERSE.LOI.F.N
|
F.INV.RT = INVERSE.LOI.F.DROITE
|
F.TEST = F.TEST
|
FISHER = FISHER
|
FISHERINV = FISHER.INVERSE
|
FORECAST.ETS = PREVISION.ETS
|
FORECAST.ETS.CONFINT = PREVISION.ETS.CONFINT
|
FORECAST.ETS.SEASONALITY = PREVISION.ETS.CARACTERESAISONNIER
|
FORECAST.ETS.STAT = PREVISION.ETS.STAT
|
FORECAST.LINEAR = PREVISION.LINEAIRE
|
FREQUENCY = FREQUENCE
|
GAMMA = GAMMA
|
GAMMA.DIST = LOI.GAMMA.N
|
GAMMA.INV = LOI.GAMMA.INVERSE.N
|
GAMMALN = LNGAMMA
|
GAMMALN.PRECISE = LNGAMMA.PRECIS
|
GAUSS = GAUSS
|
GEOMEAN = MOYENNE.GEOMETRIQUE
|
GROWTH = CROISSANCE
|
HARMEAN = MOYENNE.HARMONIQUE
|
HYPGEOM.DIST = LOI.HYPERGEOMETRIQUE.N
|
INTERCEPT = ORDONNEE.ORIGINE
|
KURT = KURTOSIS
|
LARGE = GRANDE.VALEUR
|
LINEST = DROITEREG
|
LOGEST = LOGREG
|
LOGNORM.DIST = LOI.LOGNORMALE.N
|
LOGNORM.INV = LOI.LOGNORMALE.INVERSE.N
|
MAX = MAX
|
MAXA = MAXA
|
MAXIFS = MAX.SI
|
MEDIAN = MEDIANE
|
MIN = MIN
|
MINA = MINA
|
MINIFS = MIN.SI
|
MODE.MULT = MODE.MULTIPLE
|
MODE.SNGL = MODE.SIMPLE
|
NEGBINOM.DIST = LOI.BINOMIALE.NEG.N
|
NORM.DIST = LOI.NORMALE.N
|
NORM.INV = LOI.NORMALE.INVERSE.N
|
NORM.S.DIST = LOI.NORMALE.STANDARD.N
|
NORM.S.INV = LOI.NORMALE.STANDARD.INVERSE.N
|
PEARSON = PEARSON
|
PERCENTILE.EXC = CENTILE.EXCLURE
|
PERCENTILE.INC = CENTILE.INCLURE
|
PERCENTRANK.EXC = RANG.POURCENTAGE.EXCLURE
|
PERCENTRANK.INC = RANG.POURCENTAGE.INCLURE
|
PERMUT = PERMUTATION
|
PERMUTATIONA = PERMUTATIONA
|
PHI = PHI
|
POISSON.DIST = LOI.POISSON.N
|
PROB = PROBABILITE
|
QUARTILE.EXC = QUARTILE.EXCLURE
|
QUARTILE.INC = QUARTILE.INCLURE
|
RANK.AVG = MOYENNE.RANG
|
RANK.EQ = EQUATION.RANG
|
RSQ = COEFFICIENT.DETERMINATION
|
SKEW = COEFFICIENT.ASYMETRIE
|
SKEW.P = COEFFICIENT.ASYMETRIE.P
|
SLOPE = PENTE
|
SMALL = PETITE.VALEUR
|
STANDARDIZE = CENTREE.REDUITE
|
STDEV.P = ECARTYPE.PEARSON
|
STDEV.S = ECARTYPE.STANDARD
|
STDEVA = STDEVA
|
STDEVPA = STDEVPA
|
STEYX = ERREUR.TYPE.XY
|
T.DIST = LOI.STUDENT.N
|
T.DIST.2T = LOI.STUDENT.BILATERALE
|
T.DIST.RT = LOI.STUDENT.DROITE
|
T.INV = LOI.STUDENT.INVERSE.N
|
T.INV.2T = LOI.STUDENT.INVERSE.BILATERALE
|
T.TEST = T.TEST
|
TREND = TENDANCE
|
TRIMMEAN = MOYENNE.REDUITE
|
VAR.P = VAR.P.N
|
VAR.S = VAR.S
|
VARA = VARA
|
VARPA = VARPA
|
WEIBULL.DIST = LOI.WEIBULL.N
|
Z.TEST = Z.TEST
|
|
##
|
## Fonctions de texte (Text Functions)
|
##
|
BAHTTEXT = BAHTTEXT
|
CHAR = CAR
|
CLEAN = EPURAGE
|
CODE = CODE
|
CONCAT = CONCAT
|
DOLLAR = DEVISE
|
EXACT = EXACT
|
FIND = TROUVE
|
FIXED = CTXT
|
LEFT = GAUCHE
|
LEN = NBCAR
|
LOWER = MINUSCULE
|
MID = STXT
|
NUMBERVALUE = VALEURNOMBRE
|
PHONETIC = PHONETIQUE
|
PROPER = NOMPROPRE
|
REPLACE = REMPLACER
|
REPT = REPT
|
RIGHT = DROITE
|
SEARCH = CHERCHE
|
SUBSTITUTE = SUBSTITUE
|
T = T
|
TEXT = TEXTE
|
TEXTJOIN = JOINDRE.TEXTE
|
TRIM = SUPPRESPACE
|
UNICHAR = UNICAR
|
UNICODE = UNICODE
|
UPPER = MAJUSCULE
|
VALUE = CNUM
|
|
##
|
## Fonctions web (Web Functions)
|
##
|
ENCODEURL = URLENCODAGE
|
FILTERXML = FILTRE.XML
|
WEBSERVICE = SERVICEWEB
|
|
##
|
## Fonctions de compatibilité (Compatibility Functions)
|
##
|
BETADIST = LOI.BETA
|
BETAINV = BETA.INVERSE
|
BINOMDIST = LOI.BINOMIALE
|
CEILING = PLAFOND
|
CHIDIST = LOI.KHIDEUX
|
CHIINV = KHIDEUX.INVERSE
|
CHITEST = TEST.KHIDEUX
|
CONCATENATE = CONCATENER
|
CONFIDENCE = INTERVALLE.CONFIANCE
|
COVAR = COVARIANCE
|
CRITBINOM = CRITERE.LOI.BINOMIALE
|
EXPONDIST = LOI.EXPONENTIELLE
|
FDIST = LOI.F
|
FINV = INVERSE.LOI.F
|
FLOOR = PLANCHER
|
FORECAST = PREVISION
|
FTEST = TEST.F
|
GAMMADIST = LOI.GAMMA
|
GAMMAINV = LOI.GAMMA.INVERSE
|
HYPGEOMDIST = LOI.HYPERGEOMETRIQUE
|
LOGINV = LOI.LOGNORMALE.INVERSE
|
LOGNORMDIST = LOI.LOGNORMALE
|
MODE = MODE
|
NEGBINOMDIST = LOI.BINOMIALE.NEG
|
NORMDIST = LOI.NORMALE
|
NORMINV = LOI.NORMALE.INVERSE
|
NORMSDIST = LOI.NORMALE.STANDARD
|
NORMSINV = LOI.NORMALE.STANDARD.INVERSE
|
PERCENTILE = CENTILE
|
PERCENTRANK = RANG.POURCENTAGE
|
POISSON = LOI.POISSON
|
QUARTILE = QUARTILE
|
RANK = RANG
|
STDEV = ECARTYPE
|
STDEVP = ECARTYPEP
|
TDIST = LOI.STUDENT
|
TINV = LOI.STUDENT.INVERSE
|
TTEST = TEST.STUDENT
|
VAR = VAR
|
VARP = VAR.P
|
WEIBULL = LOI.WEIBULL
|
ZTEST = TEST.Z
|
