Excel Functions in French

Fonctions Excel en Français

These are the most common Excel functions with French translations.

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

EnglishFrench
ABSABS
ADDRESSADRESSE
ANDET
AVERAGEMOYENNE
AVERAGEIFMOYENNE.SI
AVERAGEIFSMOYENNE.SI.ENS
BAHTTEXTBAHTTEXT
BIN2DECBINDEC
BIN2HEXBINHEX
CEILINGPLAFOND
CHARCAR
CHOOSECHOISIR
CODECODE
COLUMNCOLONNE
COLUMNSCOLONNES
CONCATENATECONCATENER
COUNTNB
COUNTANBVAL
COUNTBLANKNB.VIDE
COUNTIFNB.SI
COUNTIFSNB.SI.ENS
DATEDATE
DATEVALUEDATEVAL
DAYJOUR
DEC2BINDECBIN
DEC2HEXDECHEX
EOMONTHFIN.MOIS
EVENPAIR
EXACTEXACT
FACTFACT
FINDTROUVE
FLOORPLANCHER
HEX2BINHEXBIN
HEX2DECHEXDEC
HLOOKUPRECHERCHEH
HYPERLINKLIEN_HYPERTEXTE
IFSI
IFERRORSIERREUR
INDEXINDEX
INDIRECTINDIRECT
INFOINFORMATIONS
INTENT
ISBLANKESTVIDE
ISERRORESTERREUR
ISEVENEST.PAIR
ISNAESTNA
ISNONTEXTESTNONTEXTE
ISNUMBERESTNUM
ISODDEST.IMPAIR
ISTEXTESTTEXTE
LARGEGRANDE.VALEUR
LEFTGAUCHE
LENNBCAR
LOOKUPRECHERCHE
LOWERMINUSCULE
MATCHEQUIV
MAXMAX
MEDIANMEDIANE
MIDSTXT
MINMIN
MODMOD
MODEMODE
MONTHMOIS
NN
NANA
NETWORKDAYSNB.JOURS.OUVRES
NOTNON
NOWMAINTENANT
ODDIMPAIR
OFFSETDECALER
OROU
PERCENTILECENTILE
PIPI
PROPERNOMPROPRE
QUARTILEQUARTILE
RANDALEA
RANDBETWEENALEA.ENTRE.BORNES
RANKRANG
REPLACEREMPLACER
REPTREPT
RIGHTDROITE
ROMANROMAIN
ROUNDARRONDI
ROUNDDOWNARRONDI.INF
ROUNDUPARRONDI.SUP
ROWLIGNE
ROWSLIGNES
SEARCHCHERCHE
SMALLPETITE.VALEUR
STDEVECARTYPE
SUBSTITUTESUBSTITUE
SUMSOMME
SUMIFSOMME.SI
SUMIFSSOMME.SI.ENS
SUMPRODUCTSOMMEPROD
TEXTTEXTE
TODAYAUJOURDHUI
TRANSPOSETRANSPOSE
TRIMSUPPRESPACE
UPPERMAJUSCULE
VLOOKUPRECHERCHEV
WEEKDAYJOURSEM
WEEKNUMNO.SEMAINE
YEARANNEE
TRUEVRAI

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 *


one + = 7