Returns the median of the given numbers.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
MEDIAN(number1, [number2], …)The median is the number in the middle of a set of numbers. If the set contains an even number of values, the function returns the average of the two middle numbers.
=MEDIAN(1, 2, 3, 4, 5)Résultat : 3
The middle value in this set is 3.
=MEDIAN(10, 20, 30, 40)Résultat : 25
Since there are 4 numbers, it averages 20 and 30.
Empty cells, logical values, or text in references are ignored.