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