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.
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 |
Pingback: Fonctions Excel - Formules | Pearltrees
Thanks a lot is very helpful
Pingback: Translated Accounting – Esther Cervantes Business Services
Pouvez-vous publier également la version française?
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à…