Returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less.
Syntax
MEDIAN(number1,number2,...)
Number1, number2, ... are 1 to 30 numbers for which you want the median.
Remarks
-
The arguments should be either numbers or column references that contain numbers.
-
If a column reference argument contains text, logical values, or is empty, those values are ignored; however, arguments with the value zero are included.
-
If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle. See the second formula following.
Examples
Col1 |
Col2 |
Col3 |
Col4 |
Col5 |
Col6 |
Formula |
Description (Result) |
1 |
2 |
3 |
4 |
5 |
6 |
=MEDIAN([Col1],[Col2],[Col3],[Col4],[Col5]) |
Median of the first 5 numbers in the list (3) |
1 |
2 |
3 |
4 |
5 |
6 |
=MEDIAN([Col1],[Col2],[Col3],[Col4],[Col5],[Col6]) |
Median of all the numbers, or the average of 3 and 4 (3.5) |