Fonctions Excel en Français

These are the 140 most common functions in Excel with French translations. This list is very useful if you are used to the English version of Excel, and you are working with a French version that only accepts the French function names in the formulas. Or the other way around!

Normally you would also have to replace all the commas in my example formulas with semi-colon.

Do you need a list of all the function names in French in Excel? Scroll down to the bottom of this page to read more about Microsoft’s Functions Translator add-in.

English	French
ABS	ABS
ADDRESS	ADRESSE
AGGREGATE	AGREGAT
AND	ET
ARABIC	CHIFFRE.ARABE
AVERAGE	MOYENNE
AVERAGEIF	MOYENNE.SI
AVERAGEIFS	MOYENNE.SI.ENS
BAHTTEXT	BAHTTEXT
BIN2DEC	BINDEC
BIN2HEX	BINHEX
CEILING	PLAFOND
CEILING.MATH	PLAFOND.MATH
CELL	CELLULE
CHAR	CAR
CHOOSE	CHOISIR
CODE	CODE
COLUMN	COLONNE
COLUMNS	COLONNES
CONCAT	CONCAT
CONCATENATE	CONCATENER
CONVERT	CONVERT
COUNT	NB
COUNTA	NBVAL
COUNTBLANK	NB.VIDE
COUNTIF	NB.SI
COUNTIFS	NB.SI.ENS
DATE	DATE
DATEVALUE	DATEVAL
DAY	JOUR
DAYS	JOURS
DEC2BIN	DECBIN
DEC2HEX	DECHEX
EOMONTH	FIN.MOIS
EVEN	PAIR
EXACT	EXACT
FACT	FACT
FILTERXML	FILTRE.XML
FIND	TROUVE
FLOOR	PLANCHER
FLOOR.MATH	PLANCHER.MATH
FORMULATEXT	FORMULETEXTE
FREQUENCY	FREQUENCE
HEX2BIN	HEXBIN
HEX2DEC	HEXDEC
HLOOKUP	RECHERCHEH
HYPERLINK	LIEN_HYPERTEXTE
IF	SI
IFERROR	SIERREUR
IFS	SI.CONDITIONS
INDEX	INDEX
INDIRECT	INDIRECT
INFO	INFORMATIONS
INT	ENT
ISBLANK	ESTVIDE
ISERROR	ESTERREUR
ISEVEN	EST.PAIR
ISLOGICAL	ESTLOGIQUE
ISNA	ESTNA
ISNONTEXT	ESTNONTEXTE
ISNUMBER	ESTNUM
ISODD	EST.IMPAIR
ISOWEEKNUM	NO.SEMAINE.ISO
ISTEXT	ESTTEXTE
LARGE	GRANDE.VALEUR
LEFT	GAUCHE
LEN	NBCAR
LOOKUP	RECHERCHE
LOWER	MINUSCULE
MATCH	EQUIV
MAX	MAX
MAXIFS	MAX.SI
MEDIAN	MEDIANE
MID	STXT
MIN	MIN
MINIFS	MIN.SI
MOD	MOD
MODE	MODE
MONTH	MOIS
MROUND	ARRONDI.AU.MULTIPLE
N	N
NA	NA
NETWORKDAYS	NB.JOURS.OUVRES
NETWORKDAYS.INTL	NB.JOURS.OUVRES.INTL
NOT	NON
NOW	MAINTENANT
ODD	IMPAIR
OFFSET	DECALER
OR	OU
PERCENTILE	CENTILE
PERCENTILE.EXC	CENTILE.EXCLURE
PERCENTILE.INC	CENTILE.INCLURE
PERCENTRANK	RANG.POURCENTAGE
PERCENTRANK.EXC	RANG.POURCENTAGE.EXCLURE
PERCENTRANK.INC	RANG.POURCENTAGE.INCLURE
PI	PI
PMT	VPM
PROPER	NOMPROPRE
QUARTILE	QUARTILE
QUARTILE.EXC	QUARTILE.EXCLURE
QUARTILE.INC	QUARTILE.INCLURE
RAND	ALEA
RANDBETWEEN	ALEA.ENTRE.BORNES
RANK	RANG
RANK.AVG	MOYENNE.RANG
RANK.EQ	EQUATION.RANG
REPLACE	REMPLACER
REPT	REPT
RIGHT	DROITE
ROMAN	ROMAIN
ROUND	ARRONDI
ROUNDDOWN	ARRONDI.INF
ROUNDUP	ARRONDI.SUP
ROW	LIGNE
ROWS	LIGNES
SEARCH	CHERCHE
SMALL	PETITE.VALEUR
STDEV	ECARTYPE
STDEV.P	ECARTYPE.PEARSON
STDEV.S	ECARTYPE.STANDARD
SUBSTITUTE	SUBSTITUE
SUBTOTAL	SOUS.TOTAL
SUM	SOMME
SUMIF	SOMME.SI
SUMIFS	SOMME.SI.ENS
SUMPRODUCT	SOMMEPROD
SWITCH	SI.MULTIPLE
TEXT	TEXTE
TEXTJOIN	JOINDRE.TEXTE
TODAY	AUJOURDHUI
TRANSPOSE	TRANSPOSE
TRIM	SUPPRESPACE
UNICHAR	UNICAR
UNICODE	UNICODE
UPPER	MAJUSCULE
VLOOKUP	RECHERCHEV
WEEKDAY	JOURSEM
WEEKNUM	NO.SEMAINE
YEAR	ANNEE
FALSE	FAUX
TRUE	VRAI

Does Excel have a translate function?

Yes, there is an add-in called the Functions Translator add-in that you can install in a few seconds:

Go to Insert > Get Add-ins to open the add-in dialog. Choose Productivity under Category, find the Functions Translator add-in and click on the Add button.

Now you will find the Functions Translator on the Home tab to the right.

Use it to look up a functions name in a list (Reference):

Or use the Translator feature to translate a whole formula: