Returns the median of the given numbers.
Składnia
MEDIAN(number1, [number2], …)Argumenty
number1wymagane
The first number or range of numbers for which you want the median.
number2opcjonalne
Additional numbers or ranges up to 255 arguments.
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)→3The middle value in this set is 3.
=MEDIAN(10, 20, 30, 40)→25Since there are 4 numbers, it averages 20 and 30.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =MEDIAN( followed by your range of cells and a closing parenthesis.
Empty cells, logical values, or text in references are ignored.