This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.
Excel function reference
What each function does, how to write it, a worked example and the mistakes to avoid, with its name in every Excel language we support.
02Adding up
03Counting
04Logic
- SI(IF)Returns one value when a test is true and another when it's false.
- SI.CONDITIONS(IFS)Checks several tests in order and returns the result of the first true one.
- SI.MULTIPLE(SWITCH)Compares one value with a list and returns the matching result.
- ET(AND)Returns TRUE only when every test is true.
- OU(OR)Returns TRUE when at least one test is true.
- NON(NOT)Turns TRUE into FALSE and FALSE into TRUE.
- OUX(XOR)TRUE when an odd number of its tests are TRUE; with two tests, exactly one.
- ESTNUM(ISNUMBER)Checks whether a cell holds a number.
- ESTTEXTE(ISTEXT)Checks whether a cell holds text.
- ESTVIDE(ISBLANK)Checks whether a cell is empty.
- ESTERREUR(ISERROR)TRUE when a value or calculation is any error.
- SIERREUR(IFERROR)Shows your own result instead of an error.
05Lookups
- SI.NON.DISP(IFNA)Replaces only the #N/A error with your own result.
- RECHERCHEV(VLOOKUP)Finds a value in the first column of a table and returns a value from the same row.
- RECHERCHEH(HLOOKUP)Finds a value in the top row of a table and returns a value from the same column.
- RECHERCHEX(XLOOKUP)Finds a value in one range and returns the matching item from another.
06INDEX and MATCH
07Finding text
- NBCAR(LEN)Counts the characters in a text.
- GAUCHE(LEFT)Returns the first characters of a text.
- DROITE(RIGHT)Returns the last characters of a text.
- STXT(MID)Returns characters from the middle of a text.
- TROUVE(FIND)Finds where one text starts inside another. Case-sensitive.
- CHERCHE(SEARCH)Finds where one text starts inside another, ignoring case.
08Changing text
- CONCATJoins texts, cells and ranges into one text.
- JOINDRE.TEXTE(TEXTJOIN)Joins texts with a separator between them, optionally skipping empty cells.
- MAJUSCULE(UPPER)Turns all letters of a text into capitals.
- MINUSCULE(LOWER)Turns all letters of a text into small letters.
- NOMPROPRE(PROPER)Capitalises the first letter of each word.
- SUPPRESPACE(TRIM)Removes extra spaces from a text.
- SUBSTITUE(SUBSTITUTE)Replaces a piece of text with another wherever it appears.
- TEXTE.AVANT(TEXTBEFORE)Returns the text before a given separator.
- TEXTAFTERReturns the text after a given separator.
09Dates
- DATEBuilds a date from a year, a month and a day.
- AUJOURDHUI(TODAY)Returns today's date.
- ANNEE(YEAR)Returns the year of a date.
- MOIS(MONTH)Returns the month of a date, from 1 to 12.
- JOUR(DAY)Returns the day of the month of a date, from 1 to 31.
- JOURSEM(WEEKDAY)Returns the day of the week of a date as a number.
- JOURS(DAYS)Returns the number of days between two dates.
- DATEDIFCounts whole years, months or days between two dates.
- FIN.MOIS(EOMONTH)Returns the last day of a month, a number of months away.
- NB.JOURS.OUVRES(NETWORKDAYS)Counts the working days between two dates, Monday to Friday.
10Statistics
- MOYENNE(AVERAGE)Returns the average (arithmetic mean) of numbers.
- MOYENNE.SI(AVERAGEIF)Averages the numbers whose row meets one condition.
- MOYENNE.SI.ENS(AVERAGEIFS)Averages the numbers whose row meets several conditions.
- MAXReturns the largest number.
- MINReturns the smallest number.
- MAX.SI.ENS(MAXIFS)Returns the largest number whose row meets one or more conditions.
- GRANDE.VALEUR(LARGE)Returns the k-th largest number, such as the second highest.
- PETITE.VALEUR(SMALL)Returns the k-th smallest number, such as the second lowest.
- MEDIANE(MEDIAN)Returns the middle value of a set of numbers.
- MODEReturns the number that appears most often.
- EQUATION.RANG(RANK.EQ)Returns a number's rank in a list: 1 for the largest by default.
- ARRONDI(ROUND)Rounds a number to a given number of decimal places.
- PLAFOND(CEILING)Rounds a number up to the next multiple of another.
- PLANCHER(FLOOR)Rounds a number down to the previous multiple of another.
- PAIR(EVEN)Rounds a number up to the next even whole number.
- IMPAIR(ODD)Rounds a number up to the next odd whole number.