Returns the median of the given numbers.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: 3
The middle value in this set is 3.
=MEDIAN(10, 20, 30, 40)Результат: 25
Since there are 4 numbers, it averages 20 and 30.
Empty cells, logical values, or text in references are ignored.