Excel functions in French

With our upcoming Excel courses in the DRC, we have needed to make sure we know what the equivalent Excel functions are in French. With that in mind we have prepared this translation sheet which shows the English name for the Excel Function and the equivalent French Name for the main functions we teach in the beginner and the Intermediate to Advanced Courses.

For the full list look at this site

Function Fonction
IF SI
AND ET
OR OU
CLEAN EPURAGE
CONCATENATE CONCATENER
DOLLAR EURO
TEXT TEXTE
LEFT, LEFTB GAUCHE, GAUCHEB
LEN, LENB NBCAR, LENB
MID, MIDB STXT, STXTB
RIGHT, RIGHTB DROITE, DROITEB
FIND, FINDB TROUVE, TROUVERB
SEARCH, SEARCHB CHERCHE, CHERCHERB
VALUE CNUM
SUBSTITUTE SUBSTITUE
LOWER MINUSCULE
PROPER NOMPROPRE
REPT REPT
TRIM SUPPRESPACE
UPPER MAJUSCULE
HLOOKUP RECHERCHEH
VLOOKUP RECHERCHEV
RANK RANG
IFERROR SIERREUR
ISERROR ESTERREUR
AVERAGEIF MOYENNE.SI
AVERAGEIFS MOYENNE.SI
COUNTIF NB.SI
COUNTIFS NB.SI.ENS
LARGE GRANDE.VALEUR
MAX MAX
MIN MIN
SUM SOMME
SUMIF SOMME.SI
SUMIFS SOMME.SI.ENS
SUMPRODUCT SOMMEPROD
CHOOSE CHOISIR
TRANSPOSE TRANSPOSE
DATE DATE
DAY JOUR
MONTH MOIS
YEAR ANNEE
EOMONTH FIN.MOIS
WEEKDAY JOURSEM
WEEKNUM NO.SEMAINE
WORKDAY SERIE.JOUR.OUVRE
NETWORKDAYS NB.JOURS.OUVRES
DATEVALUE DATEVAL
DAYS360 JOURS360
YEARFRAC FRACTION.ANNEE