Excel Functions in French

These are the most common Excel functions with French translations.

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


English French
ABS ABS
ADDRESS ADRESSE
AND ET
AVERAGE MOYENNE
AVERAGEIF MOYENNE.SI
AVERAGEIFS MOYENNE.SI.ENS
BAHTTEXT BAHTTEXT
BIN2DEC BINDEC
BIN2HEX BINHEX
CEILING PLAFOND
CHAR CAR
CHOOSE CHOISIR
CODE CODE
COLUMN COLONNE
COLUMNS COLONNES
CONCATENATE CONCATENER
COUNT NB
COUNTA NBVAL
COUNTBLANK NB.VIDE
COUNTIF NB.SI
COUNTIFS NB.SI.ENS
DATE DATE
DATEVALUE DATEVAL
DAY JOUR
DEC2BIN DECBIN
DEC2HEX DECHEX
EOMONTH FIN.MOIS
EVEN PAIR
EXACT EXACT
FACT FACT
FIND TROUVE
FLOOR PLANCHER
HEX2BIN HEXBIN
HEX2DEC HEXDEC
HLOOKUP RECHERCHEH
HYPERLINK LIEN_HYPERTEXTE
IF SI
IFERROR SIERREUR
INDEX INDEX
INDIRECT INDIRECT
INFO INFORMATIONS
INT ENT
ISBLANK ESTVIDE
ISERROR ESTERREUR
ISEVEN EST.PAIR
ISNA ESTNA
ISNONTEXT ESTNONTEXTE
ISNUMBER ESTNUM
ISODD EST.IMPAIR
ISTEXT ESTTEXTE
LARGE GRANDE.VALEUR
LEFT GAUCHE
LEN NBCAR
LOOKUP RECHERCHE
LOWER MINUSCULE
MATCH EQUIV
MAX MAX
MEDIAN MEDIANE
MID STXT
MIN MIN
MOD MOD
MODE MODE
MONTH MOIS
N N
NA NA
NETWORKDAYS NB.JOURS.OUVRES
NOT NON
NOW MAINTENANT
ODD IMPAIR
OFFSET DECALER
OR OU
PERCENTILE CENTILE
PI PI
PROPER NOMPROPRE
QUARTILE QUARTILE
RAND ALEA
RANDBETWEEN ALEA.ENTRE.BORNES
RANK 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
SUBSTITUTE SUBSTITUE
SUM SOMME
SUMIF SOMME.SI
SUMIFS SOMME.SI.ENS
SUMPRODUCT SOMMEPROD
TEXT TEXTE
TODAY AUJOURDHUI
TRANSPOSE TRANSPOSE
TRIM SUPPRESPACE
UPPER MAJUSCULE
VLOOKUP RECHERCHEV
WEEKDAY JOURSEM
WEEKNUM NO.SEMAINE
YEAR ANNEE
TRUE VRAI


One thought on “Excel Functions in French

  1. Pingback: Fonctions Excel - Formules | Pearltrees

Leave a Reply

Your email address will not be published. Required fields are marked *


4 + = nine

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>