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) |