Categories
Excel function translations English to French
A list of Excel function translations from English to French. If you’re familiar with the English version of Excel and you find yourself working with the French version, this list will be of use to you, because Excel functions have different names in different languages.
List of all Excel functions
translated from English to French
English | French |
ABS | ABS |
ACCRINT | INTERET.ACC |
ACCRINTM | INTERET.ACC.MAT |
ACOS | ACOS |
ACOSH | ACOSH |
ACOT | ACOT |
ACOTH | ACOTH |
ADDRESS | ADRESSE |
AGGREGATE | AGREGAT |
AMORDEGRC | AMORDEGRC |
AMORLINC | AMORLINC |
AND | ET |
ARABIC | CHIFFRE.ARABE |
AREAS | ZONES |
ASC | ASC |
ASIN | ASIN |
ASINH | ASINH |
ATAN | ATAN |
ATAN2 | ATAN2 |
ATANH | ATANH |
AVEDEV | ECART.MOYEN |
AVERAGE | MOYENNE |
AVERAGEA | AVERAGEA |
AVERAGEIF | MOYENNE.SI |
AVERAGEIFS | MOYENNE.SI.ENS |
BAHTTEXT | BAHTTEXT |
BASE | BASE |
BESSELI | BESSELI |
BESSELJ | BESSELJ |
BESSELK | BESSELK |
BESSELY | BESSELY |
BETA.DIST | LOI.BETA.N |
BETA.INV | BETA.INVERSE.N |
BETADIST | LOI.BETA |
BETAINV | BETA.INVERSE |
BIN2DEC | BINDEC |
BIN2HEX | BINHEX |
BIN2OCT | BINOCT |
BINOM.DIST | LOI.BINOMIALE.N |
BINOM.DIST.RANGE | BINOM.DIST.RANGE |
BINOM.INV | LOI.BINOMIALE.INVERSE |
BINOMDIST | LOI.BINOMIALE |
BITAND | BITET |
BITLSHIFT | BITLSHIFT |
BITOR | BITOU |
BITRSHIFT | BITDECALD |
BITXOR | BITOUEXCLUSIF |
CALL | FONCTION.APPELANTE |
CEILING | PLAFOND |
CEILING.MATH | PLAFOND.MATH |
CEILING.PRECISE | PLAFOND.PRECIS |
CELL | CELLULE |
CHAR | CAR |
CHIDIST | LOI.KHIDEUX |
CHIINV | KHIDEUX.INVERSE |
CHISQ.DIST | LOI.KHIDEUX |
CHISQ.DIST.RT | LOI.KHIDEUX.DROITE |
CHISQ.INV | LOI.KHIDEUX.INVERSE |
CHISQ.INV.RT | LOI.KHIDEUX.INVERSE.DROITE |
CHISQ.TEST | CHISQ.TEST |
CHITEST | TEST.KHIDEUX |
CHOOSE | CHOISIR |
CLEAN | EPURAGE |
CODE | CODE |
COLUMN | COLONNE |
COLUMNS | COLONNES |
COMBIN | COMBIN |
COMBINA | COMBINA |
COMPLEX | COMPLEXE |
CONCATENATE | CONCATENER |
CONFIDENCE | INTERVALLE.CONFIANCE |
CONFIDENCE.NORM | INTERVALLE.CONFIANCE.NORMAL |
CONFIDENCE.T | INTERVALLE.CONFIANCE.STUDENT |
CONVERT | CONVERT |
CORREL | COEFFICIENT.CORRELATION |
COS | COS |
COSH | COSH |
COT | COT |
COTH | COTH |
COUNT | NB |
COUNTA | NBVAL |
COUNTBLANK | NB.VIDE |
COUNTIF | NB.SI |
COUNTIFS | NB.SI.ENS |
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 |
COVAR | COVARIANCE |
COVARIANCE.P | COVARIANCE.PEARSON |
COVARIANCE.S | COVARIANCE.STANDARD |
CRITBINOM | CRITERE.LOI.BINOMIALE |
CSC | CSC |
CSCH | CSCH |
CUBEKPIMEMBER | MEMBREKPICUBE |
CUBEMEMBER | MEMBRECUBE |
CUBEMEMBERPROPERTY | PROPRIETEMEMBRECUBE |
CUBERANKEDMEMBER | RANGMEMBRECUBE |
CUBESET | JEUCUBE |
CUBESETCOUNT | NBJEUCUBE |
CUBEVALUE | VALEURCUBE |
CUMIPMT | CUMUL.INTER |
CUMPRINC | CUMUL.PRINCPER |
DATE | DATE |
DATEVALUE | DATEVAL |
DAVERAGE | BDMOYENNE |
DAY | JOUR |
DAYS | JOURS |
DAYS360 | JOURS360 |
DB | DB |
DBCS | DBCS |
DCOUNT | BDNB |
DCOUNTA | BDNBVAL |
DDB | DDB |
DEC2BIN | DECBIN |
DEC2HEX | DECHEX |
DEC2OCT | DECOCT |
DECIMAL | DECIMAL |
DEGREES | DEGRES |
DELTA | DELTA |
DEVSQ | SOMME.CARRES.ECARTS |
DGET | BDLIRE |
DISC | TAUX.ESCOMPTE |
DMAX | BDMAX |
DMIN | BDMIN |
DOLLAR | DEVISE |
DOLLARDE | PRIX.DEC |
DOLLARFR | PRIX.FRAC |
DPRODUCT | BDPRODUIT |
DSTDEV | BDECARTYPE |
DSTDEVP | BDECARTYPEP |
DSUM | BDSOMME |
DURATION | DUREE |
DVAR | BDVAR |
DVARP | BDVARP |
EDATE | MOIS.DECALER |
EFFECT | TAUX.EFFECTIF |
ENCODEURL | ENCODEURL |
EOMONTH | FIN.MOIS |
ERF | ERF |
ERF.PRECISE | ERF.PRECIS |
ERFC | ERFC |
ERFC.PRECISE | ERFC.PRECIS |
ERROR.TYPE | TYPE.ERREUR |
EUROCONVERT | EUROCONVERT |
EVEN | PAIR |
EXACT | EXACT |
EXP | EXP |
EXPON.DIST | LOI.EXPONENTIELLE.N |
EXPONDIST | LOI.EXPONENTIELLE |
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 |
FACT | FACT |
FACTDOUBLE | FACTDOUBLE |
FALSE | FAUX |
FDIST | LOI.F |
FILTERXML | FILTRE.XML |
FIND, FINDB | TROUVE, TROUVERB |
FINV | INVERSE.LOI.F |
FISHER | FISHER |
FISHERINV | FISHER.INVERSE |
FIXED | CTXT |
FLOOR | PLANCHER |
FLOOR.MATH | PLANCHER.MATH |
FLOOR.PRECISE | PLANCHER.PRECIS |
FORECAST | PREVISION |
FORMULATEXT | FORMULATEXT |
FREQUENCY | FREQUENCE |
FTEST | TEST.F |
FV | VC |
FVSCHEDULE | VC.PAIEMENTS |
GAMMA | GAMMA |
GAMMA.DIST | LOI.GAMMA.N |
GAMMA.INV | LOI.GAMMA.INVERSE.N |
GAMMADIST | LOI.GAMMA |
GAMMAINV | LOI.GAMMA.INVERSE |
GAMMALN | LNGAMMA |
GAMMALN.PRECISE | LNGAMMA.PRECIS |
GAUSS | GAUSS |
GCD | PGCD |
GEOMEAN | MOYENNE.GEOMETRIQUE |
GESTEP | SUP.SEUIL |
GETPIVOTDATA | LIREDONNEESTABCROISDYNAMIQUE |
GROWTH | CROISSANCE |
HARMEAN | MOYENNE.HARMONIQUE |
HEX2BIN | HEXBIN |
HEX2DEC | HEXDEC |
HEX2OCT | HEXOCT |
HLOOKUP | RECHERCHEH |
HOUR | HEURE |
HYPERLINK | LIEN_HYPERTEXTE |
HYPGEOM.DIST | LOI.HYPERGEOMETRIQUE.N |
HYPGEOMDIST | LOI.HYPERGEOMETRIQUE |
IF | SI |
IFERROR | SIERREUR |
IFNA | SI.NON.DISP |
IMABS | COMPLEXE.MODULE |
IMAGINARY | COMPLEXE.IMAGINAIRE |
IMARGUMENT | COMPLEXE.ARGUMENT |
IMCONJUGATE | COMPLEXE.CONJUGUE |
IMCOS | COMPLEXE.COS |
IMCOSH | COMPLEXE.COSH |
IMCOT | IMCOT |
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 | IMTAN |
INDEX | INDEX |
INDIRECT | INDIRECT |
INFO | INFORMATIONS |
INT | ENT |
INTERCEPT | ORDONNEE.ORIGINE |
INTRATE | TAUX.INTERET |
IPMT | INTPER |
IRR | TRI |
ISBLANK | ESTVIDE |
ISERR | ESTERR |
ISERROR | ESTERREUR |
ISEVEN | EST.PAIR |
ISFORMULA | ISFORMULA |
ISLOGICAL | ESTLOGIQUE |
ISNA | ESTNA |
ISNONTEXT | ESTNONTEXTE |
ISNUMBER | ESTNUM |
ISO.CEILING | ISO.PLAFOND |
ISODD | EST.IMPAIR |
ISOWEEKNUM | ISOWEEKNUM |
ISPMT | ISPMT |
ISREF | ESTREF |
ISTEXT | ESTTEXTE |
KURT | KURTOSIS |
LARGE | GRANDE.VALEUR |
LCM | PPCM |
LEFT, LEFTB | GAUCHE, GAUCHEB |
LEN, LENB | NBCAR, LENB |
LINEST | DROITEREG |
LN | LN |
LOG | LOG |
LOG10 | LOG10 |
LOGEST | LOGREG |
LOGINV | LOI.LOGNORMALE.INVERSE |
LOGNORM.DIST | LOI.LOGNORMALE.N |
LOGNORM.INV | LOI.LOGNORMALE.INVERSE.N |
LOGNORMDIST | LOI.LOGNORMALE |
LOOKUP | RECHERCHE |
LOWER | MINUSCULE |
MATCH | EQUIV |
MAX | MAX |
MAXA | MAXA |
MDETERM | DETERMAT |
MDURATION | DUREE.MODIFIEE |
MEDIAN | MEDIANE |
MID, MIDB | STXT, MIDB |
MIN | MIN |
MINA | MINA |
MINUTE | MINUTE |
MINVERSE | INVERSEMAT |
MIRR | TRIM |
MMULT | PRODUITMAT |
MOD | MOD |
MODE | MODE |
MODE.MULT | MODE.MULTIPLE |
MODE.SNGL | MODE.SIMPLE |
MONTH | MOIS |
MROUND | ARRONDI.AU.MULTIPLE |
MULTINOMIAL | MULTINOMIALE |
MUNIT | MATRICE.UNITAIRE |
N | N |
NA | NA |
NEGBINOM.DIST | LOI.BINOMIALE.NEG.N |
NEGBINOMDIST | LOI.BINOMIALE.NEG |
NETWORKDAYS | NB.JOURS.OUVRES |
NETWORKDAYS.INTL | NB.JOURS.OUVRES.INTL |
NOMINAL | TAUX.NOMINAL |
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 |
NORMDIST | LOI.NORMALE |
NORMINV | LOI.NORMALE.INVERSE |
NORMSDIST | LOI.NORMALE.STANDARD |
NORMSINV | LOI.NORMALE.STANDARD.INVERSE |
NOT | NON |
NOW | MAINTENANT |
NPER | NPM |
NPV | VAN |
NUMBERVALUE | NUMBERVALUE |
OCT2BIN | OCTBIN |
OCT2DEC | OCTDEC |
OCT2HEX | OCTHEX |
ODD | IMPAIR |
ODDFPRICE | PRIX.PCOUPON.IRREG |
ODDFYIELD | REND.PCOUPON.IRREG |
ODDLPRICE | PRIX.DCOUPON.IRREG |
ODDLYIELD | REND.DCOUPON.IRREG |
OFFSET | DECALER |
OR | OU |
PDURATION | PDURATION |
PEARSON | PEARSON |
PERCENTILE | CENTILE |
PERCENTILE.EXC | CENTILE.EXCLURE |
PERCENTILE.INC | CENTILE.INCLURE |
PERCENTRANK | RANG.POURCENTAGE |
PERCENTRANK.EXC | RANG.POURCENTAGE.EXCLURE |
PERCENTRANK.INC | RANG.POURCENTAGE.INCLURE |
PERMUT | PERMUTATION |
PERMUTATIONA | PERMUTATIONA |
PHI | PHI |
PHONETIC | PHONETIQUE |
PI | PI |
PMT | VPM |
POISSON | LOI.POISSON |
POISSON.DIST | LOI.POISSON.N |
POWER | PUISSANCE |
PPMT | PRINCPER |
PRICE | PRIX.TITRE |
PRICEDISC | VALEUR.ENCAISSEMENT |
PRICEMAT | PRIX.TITRE.ECHEANCE |
PROB | PROBABILITE |
PRODUCT | PRODUIT |
PROPER | NOMPROPRE |
PV | VA |
QUARTILE | QUARTILE |
QUARTILE.EXC | QUARTILE.EXCLURE |
QUARTILE.INC | QUARTILE.INCLURE |
QUOTIENT | QUOTIENT |
RADIANS | RADIANS |
RAND | ALEA |
RANDBETWEEN | ALEA.ENTRE.BORNES |
RANK | RANG |
RANK.AVG | MOYENNE.RANG |
RANK.EQ | EQUATION.RANG |
RATE | TAUX |
RECEIVED | VALEUR.NOMINALE |
REGISTER.ID | REGISTRE.NUMERO |
REPLACE, REPLACEB | REMPLACER, REMPLACERB |
REPT | REPT |
RIGHT, RIGHTB | DROITE, DROITEB |
ROMAN | ROMAIN |
ROUND | ARRONDI |
ROUNDDOWN | ARRONDI.INF |
ROUNDUP | ARRONDI.SUP |
ROW | LIGNE |
ROWS | LIGNES |
RRI | TAUX.INT.EQUIV |
RSQ | COEFFICIENT.DETERMINATION |
RTD | RTD |
SEARCH, SEARCHB | CHERCHE, CHERCHERB |
SEC | SEC |
SECH | SECH |
SECOND | SECONDE |
SERIESSUM | SOMME.SERIES |
SHEET | FEUILLE |
SHEETS | SHEETS |
SIGN | SIGNE |
SIN | SIN |
SINH | SINH |
SKEW | COEFFICIENT.ASYMETRIE |
SKEW.P | SKEW.P |
SLN | AMORLIN |
SLOPE | PENTE |
SMALL | PETITE.VALEUR |
SQL.REQUEST | SQL.REQUEST |
SQRT | RACINE |
SQRTPI | RACINE.PI |
STANDARDIZE | CENTREE.REDUITE |
STDEV | ECARTYPE |
STDEV.P | ECARTYPE.PEARSON |
STDEV.S | ECARTYPE.STANDARD |
STDEVA | STDEVA |
STDEVP | ECARTYPEP |
STDEVPA | STDEVPA |
STEYX | ERREUR.TYPE.XY |
SUBSTITUTE | SUBSTITUE |
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 |
SYD | SYD |
T | T |
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 |
TAN | TAN |
TANH | TANH |
TBILLEQ | TAUX.ESCOMPTE.R |
TBILLPRICE | PRIX.BON.TRESOR |
TBILLYIELD | RENDEMENT.BON.TRESOR |
TDIST | LOI.STUDENT |
TEXT | TEXTE |
TIME | TEMPS |
TIMEVALUE | TEMPSVAL |
TINV | LOI.STUDENT.INVERSE |
TODAY | AUJOURDHUI |
TRANSPOSE | TRANSPOSE |
TREND | TENDANCE |
TRIM | SUPPRESPACE |
TRIMMEAN | MOYENNE.REDUITE |
TRUE | VRAI |
TRUNC | TRONQUE |
TTEST | TEST.STUDENT |
TYPE | TYPE |
UNICHAR | UNICAR |
UNICODE | UNICODE |
UPPER | MAJUSCULE |
VALUE | CNUM |
VAR | VAR |
VAR.P | VAR.P |
VAR.S | VAR.S |
VARA | VARA |
VARP | VARP |
VARPA | VARPA |
VDB | VDB |
VLOOKUP | RECHERCHEV |
WEBSERVICE | SERVICEWEB |
WEEKDAY | JOURSEM |
WEEKNUM | NO.SEMAINE |
WEIBULL | LOI.WEIBULL |
WEIBULL.DIST | LOI.WEIBULL.N |
WORKDAY | SERIE.JOUR.OUVRE |
WORKDAY.INTL | SERIE.JOUR.OUVRE.INTL |
XIRR | TRI.PAIEMENTS |
XLOOKUP | RECHERCHEX |
XNPV | VAN.PAIEMENTS |
XOR | OUX |
YEAR | ANNEE |
YEARFRAC | FRACTION.ANNEE |
YIELD | RENDEMENT.TITRE |
YIELDDISC | RENDEMENT.SIMPLE |
YIELDMAT | RENDEMENT.TITRE.ECHEANCE |
Z.TEST | Z.TEST |
ZTEST | TEST.Z |