Excel Functions in French

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.

EnglishFrench
ABSABS
ADDRESSADRESSE
AGGREGATEAGREGAT
ANDET
ARABICCHIFFRE.ARABE
AVERAGEMOYENNE
AVERAGEIFMOYENNE.SI
AVERAGEIFSMOYENNE.SI.ENS
BAHTTEXTBAHTTEXT
BIN2DECBINDEC
BIN2HEXBINHEX
CEILINGPLAFOND
CEILING.MATHPLAFOND.MATH
CELLCELLULE
CHARCAR
CHOOSECHOISIR
CODECODE
COLUMNCOLONNE
COLUMNSCOLONNES
CONCATCONCAT
CONCATENATECONCATENER
CONVERTCONVERT
COUNTNB
COUNTANBVAL
COUNTBLANKNB.VIDE
COUNTIFNB.SI
COUNTIFSNB.SI.ENS
DATEDATE
DATEVALUEDATEVAL
DAYJOUR
DAYSJOURS
DEC2BINDECBIN
DEC2HEXDECHEX
EOMONTHFIN.MOIS
EVENPAIR
EXACTEXACT
FACTFACT
FILTERXMLFILTRE.XML
FINDTROUVE
FLOORPLANCHER
FLOOR.MATHPLANCHER.MATH
FORMULATEXTFORMULETEXTE
FREQUENCYFREQUENCE
HEX2BINHEXBIN
HEX2DECHEXDEC
HLOOKUPRECHERCHEH
HYPERLINKLIEN_HYPERTEXTE
IFSI
IFERRORSIERREUR
IFSSI.CONDITIONS
INDEXINDEX
INDIRECTINDIRECT
INFOINFORMATIONS
INTENT
ISBLANKESTVIDE
ISERRORESTERREUR
ISEVENEST.PAIR
ISLOGICALESTLOGIQUE
ISNAESTNA
ISNONTEXTESTNONTEXTE
ISNUMBERESTNUM
ISODDEST.IMPAIR
ISOWEEKNUMNO.SEMAINE.ISO
ISTEXTESTTEXTE
LARGEGRANDE.VALEUR
LEFTGAUCHE
LENNBCAR
LOOKUPRECHERCHE
LOWERMINUSCULE
MATCHEQUIV
MAXMAX
MAXIFSMAX.SI
MEDIANMEDIANE
MIDSTXT
MINMIN
MINIFSMIN.SI
MODMOD
MODEMODE
MONTHMOIS
MROUNDARRONDI.AU.MULTIPLE
NN
NANA
NETWORKDAYSNB.JOURS.OUVRES
NETWORKDAYS.INTLNB.JOURS.OUVRES.INTL
NOTNON
NOWMAINTENANT
ODDIMPAIR
OFFSETDECALER
OROU
PERCENTILECENTILE
PERCENTILE.EXCCENTILE.EXCLURE
PERCENTILE.INCCENTILE.INCLURE
PERCENTRANKRANG.POURCENTAGE
PERCENTRANK.EXCRANG.POURCENTAGE.EXCLURE
PERCENTRANK.INCRANG.POURCENTAGE.INCLURE
PIPI
PMTVPM
PROPERNOMPROPRE
QUARTILEQUARTILE
QUARTILE.EXCQUARTILE.EXCLURE
QUARTILE.INCQUARTILE.INCLURE
RANDALEA
RANDBETWEENALEA.ENTRE.BORNES
RANKRANG
RANK.AVGMOYENNE.RANG
RANK.EQEQUATION.RANG
REPLACEREMPLACER
REPTREPT
RIGHTDROITE
ROMANROMAIN
ROUNDARRONDI
ROUNDDOWNARRONDI.INF
ROUNDUPARRONDI.SUP
ROWLIGNE
ROWSLIGNES
SEARCHCHERCHE
SMALLPETITE.VALEUR
STDEVECARTYPE
STDEV.PECARTYPE.PEARSON
STDEV.SECARTYPE.STANDARD
SUBSTITUTESUBSTITUE
SUBTOTALSOUS.TOTAL
SUMSOMME
SUMIFSOMME.SI
SUMIFSSOMME.SI.ENS
SUMPRODUCTSOMMEPROD
SWITCHSI.MULTIPLE
TEXTTEXTE
TEXTJOINJOINDRE.TEXTE
TODAYAUJOURDHUI
TRANSPOSETRANSPOSE
TRIMSUPPRESPACE
UNICHARUNICAR
UNICODEUNICODE
UPPERMAJUSCULE
VLOOKUPRECHERCHEV
WEEKDAYJOURSEM
WEEKNUMNO.SEMAINE
YEARANNEE
FALSEFAUX
TRUEVRAI

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.

Click on the picture to magnify

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:

5 thoughts on “Excel Functions in French

  1. Pingback: Fonctions Excel - Formules | Pearltrees

  2. Pingback: Translated Accounting – Esther Cervantes Business Services

  3. Well, there isn’t a lot of functions here, just the basic ones that a google translate can find. It would be cool to add the tricky functions as well…

    —————————————————————————————

    Bon, ya pas grand chose dans la liste proposée, seulement les plus fonction les plus basiques que même google trad arrive à nous donner. Il aurait été sympa dans un tel article de mettre des fonctions plus complexe, autrement le pourquoi on est là…

Leave a Reply

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


× 6 = eighteen