홈으로

Guide des Fonctions Excel

Trouvez facilement les fonctions Excel les plus utilisées et apprenez à les utiliser. Organisées par diverses catégories incluant les fonctions mathématiques, texte, date et logiques.

📊 Guide Complet des Fonctions Excel

Les fonctions Excel couramment utilisées au travail sont organisées par catégorie. Vérifiez la syntaxe, les paramètres et les exemples de chaque fonction et copiez-les dans le presse-papiers pour une utilisation immédiate.

SUM

Description

Calcule la somme des nombres.

Syntaxe

SUM(number1, [number2], ...)

Paramètres

  • number1*:Premier nombre ou plage
  • number2:Nombres ou plages supplémentaires (optionnel)

Exemple

=SUM(A1:A10)

Somme de A1 à A10

AVERAGE

Description

Calcule la moyenne des nombres.

Syntaxe

AVERAGE(number1, [number2], ...)

Paramètres

  • number1*:Premier nombre ou plage
  • number2:Nombres ou plages supplémentaires (optionnel)

Exemple

=AVERAGE(A1:A10)

Moyenne de A1 à A10

COUNT

Description

Compte le nombre de cellules contenant des nombres.

Syntaxe

COUNT(value1, [value2], ...)

Paramètres

  • value1*:Première valeur ou plage
  • value2:Valeurs ou plages supplémentaires (optionnel)

Exemple

=COUNT(A1:A10)

Nombre de cellules avec des nombres de A1 à A10

MAX

Description

Returns the largest value.

Syntaxe

MAX(number1, [number2], ...)

Paramètres

  • number1*:First number or range
  • number2:Additional numbers or ranges (optional)

Exemple

=MAX(A1:A10)

Maximum value from A1 to A10

MIN

Description

Returns the smallest value.

Syntaxe

MIN(number1, [number2], ...)

Paramètres

  • number1*:First number or range
  • number2:Additional numbers or ranges (optional)

Exemple

=MIN(A1:A10)

Minimum value from A1 to A10

ROUND

Description

Rounds a number to specified digits.

Syntaxe

ROUND(number, num_digits)

Paramètres

  • number*:number
  • num_digits*:num_digits

Exemple

=ROUND(3.14159, 2)

3.14

CONCATENATE

Description

Joins several text strings into one.

Syntaxe

CONCATENATE(text1, [text2], ...)

Paramètres

  • text1*:text1
  • text2:text2

Exemple

=CONCATENATE(A1, " ", B1)

A1 and B1 joined with space

LEFT

Description

Returns specified number of characters from the left.

Syntaxe

LEFT(text, [num_chars])

Paramètres

  • text*:Source text
  • num_chars:Number of characters to extract (default: 1)

Exemple

=LEFT(A1, 5)

Left 5 characters of A1

RIGHT

Description

Returns specified number of characters from the right.

Syntaxe

RIGHT(text, [num_chars])

Paramètres

  • text*:Source text
  • num_chars:Number of characters to extract (default: 1)

Exemple

=RIGHT(A1, 3)

Right 3 characters of A1

MID

Description

Returns specified number of characters from the middle.

Syntaxe

MID(text, start_num, num_chars)

Paramètres

  • text*:Source text
  • start_num*:Starting position
  • num_chars*:Number of characters to extract

Exemple

=MID(A1, 3, 5)

5 characters from position 3 of A1

LEN

Description

Returns the number of characters in text.

Syntaxe

LEN(text)

Paramètres

  • text*:Text to count characters

Exemple

=LEN(A1)

Number of characters in A1

UPPER

Description

Converts text to uppercase.

Syntaxe

UPPER(text)

Paramètres

  • text*:Text to convert

Exemple

=UPPER(A1)

A1 converted to uppercase

LOWER

Description

Converts text to lowercase.

Syntaxe

LOWER(text)

Paramètres

  • text*:Text to convert

Exemple

=LOWER(A1)

A1 converted to lowercase

TODAY

Description

Returns current date.

Syntaxe

TODAY()

Exemple

=TODAY()

Today's date

NOW

Description

Returns current date and time.

Syntaxe

NOW()

Exemple

=NOW()

Current date and time

YEAR

Description

Extracts the year from a date.

Syntaxe

YEAR(serial_number)

Paramètres

  • serial_number*:Date value

Exemple

=YEAR(A1)

Year of A1 date

MONTH

Description

Extracts the month from a date.

Syntaxe

MONTH(serial_number)

Paramètres

  • serial_number*:Date value

Exemple

=MONTH(A1)

Month of A1 date

DAY

Description

Extracts the day from a date.

Syntaxe

DAY(serial_number)

Paramètres

  • serial_number*:Date value

Exemple

=DAY(A1)

Day of A1 date

DATEDIF

Description

Calculates the difference between two dates.

Syntaxe

DATEDIF(start_date, end_date, unit)

Paramètres

  • start_date*:Start date
  • end_date*:End date
  • unit*:Unit (Y, M, D, etc.)

Exemple

=DATEDIF(A1, B1, "Y")

Years between A1 and B1

IF

Description

Retourne différentes valeurs basées sur une condition.

Syntaxe

IF(logical_test, [value_if_true], [value_if_false])

Paramètres

  • logical_test*:Condition à tester
  • value_if_true:Valeur si la condition est vraie
  • value_if_false:Valeur si la condition est fausse

Exemple

=IF(A1>10, "Large", "Small")

'Grand' si A1>10, sinon 'Petit'

AND

Description

Returns TRUE if all arguments are TRUE.

Syntaxe

AND(logical1, [logical2], ...)

Paramètres

  • logical1*:First condition
  • logical2:Additional conditions (optional)

Exemple

=AND(A1>5, B1<10)

TRUE if A1>5 AND B1<10

OR

Description

Returns TRUE if any argument is TRUE.

Syntaxe

OR(logical1, [logical2], ...)

Paramètres

  • logical1*:First condition
  • logical2:Additional conditions (optional)

Exemple

=OR(A1>5, B1<10)

TRUE if A1>5 OR B1<10

NOT

Description

Reverses the logical value.

Syntaxe

NOT(logical)

Paramètres

  • logical*:Logical value

Exemple

=NOT(A1>10)

TRUE if A1 is NOT greater than 10

VLOOKUP

Description

Recherche verticalement dans un tableau et retourne une valeur.

Syntaxe

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Paramètres

  • lookup_value*:Valeur à rechercher
  • table_array*:Plage de tableau à rechercher
  • col_index_num*:Numéro de colonne à retourner
  • range_lookup:Correspondance exacte (FALSE) ou approximative (TRUE)

Exemple

=VLOOKUP(A1, C1:E10, 2, FALSE)

Trouve A1 dans C1:E10 et retourne la valeur de la 2e colonne

HLOOKUP

Description

Searches horizontally in a table and returns a value.

Syntaxe

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Paramètres

  • lookup_value*:Value to search for
  • table_array*:Table range to search
  • row_index_num*:Row number to return
  • range_lookup:Exact match (FALSE) or approximate (TRUE)

Exemple

=HLOOKUP(A1, C1:G3, 2, FALSE)

Find A1 in C1:G3 and return 2nd row value

INDEX

Description

Returns a value from a specific position in an array.

Syntaxe

INDEX(array, row_num, [column_num])

Paramètres

  • array*:Data array
  • row_num*:Row number
  • column_num:Column number (optional)

Exemple

=INDEX(A1:C10, 3, 2)

Value at row 3, column 2 of A1:C10

MATCH

Description

Finds the position of a value in an array.

Syntaxe

MATCH(lookup_value, lookup_array, [match_type])

Paramètres

  • lookup_value*:Value to find
  • lookup_array*:Array to search
  • match_type:Match type (0, 1, -1)

Exemple

=MATCH(A1, B1:B10, 0)

Position of A1 value in B1:B10

COUNTIF

Description

Counts cells that meet a condition.

Syntaxe

COUNTIF(range, criteria)

Paramètres

  • range*:Range to check
  • criteria*:Condition

Exemple

=COUNTIF(A1:A10, ">5")

Count of values greater than 5 in A1:A10

SUMIF

Description

Sums cells that meet a condition.

Syntaxe

SUMIF(range, criteria, [sum_range])

Paramètres

  • range*:Range to check condition
  • criteria*:Condition
  • sum_range:Range to sum (optional)

Exemple

=SUMIF(A1:A10, ">5")

Sum of values greater than 5 in A1:A10

AVERAGEIF

Description

Averages cells that meet a condition.

Syntaxe

AVERAGEIF(range, criteria, [average_range])

Paramètres

  • range*:Range to check condition
  • criteria*:Condition
  • average_range:Range to average (optional)

Exemple

=AVERAGEIF(A1:A10, ">5")

Average of values greater than 5 in A1:A10

STDEV

Description

Calculates standard deviation (sample).

Syntaxe

STDEV(number1, [number2], ...)

Paramètres

  • number1*:First number or range
  • number2:Additional numbers or ranges (optional)

Exemple

=STDEV(A1:A10)

Standard deviation of A1 to A10

PMT

Description

Calculates loan payment amount.

Syntaxe

PMT(rate, nper, pv, [fv], [type])

Paramètres

  • rate*:Interest rate
  • nper*:Total number of payments
  • pv*:Present value (loan principal)
  • fv:Future value (optional)
  • type:Payment timing (optional)

Exemple

=PMT(5%/12, 60, 100000)

Monthly payment for 5% annual rate, 5-year, $100,000 loan

FV

Description

Calculates future value of investment.

Syntaxe

FV(rate, nper, pmt, [pv], [type])

Paramètres

  • rate*:Interest rate
  • nper*:Total periods
  • pmt*:Periodic payment
  • pv:Present value (optional)
  • type:Payment timing (optional)

Exemple

=FV(8%/12, 120, -1000)

Future value of $1000 monthly savings at 8% annual rate for 10 years

PV

Description

Calculates present value of investment.

Syntaxe

PV(rate, nper, pmt, [fv], [type])

Paramètres

  • rate*:Interest rate
  • nper*:Total periods
  • pmt*:Periodic payment
  • fv:Future value (optional)
  • type:Payment timing (optional)

Exemple

=PV(8%/12, 120, 1000)

Present value of $1000 monthly payments at 8% annual rate for 10 years