The MEDIAN function returns the median value in a set of numbers. The median is the value where half the values in the set are less than the median and half are greater.
MEDIAN(value, value…)
value: Any value or collection. Date/time values or duration values can’t be mixed with other value types. If either of these value types is included, all values must be of the same value type. A string value or boolean value can be included in a referenced cell, but can’t be entered directly as an argument to the function.
value…: Optionally include one or more additional values or collections.
Notes
A string value or boolean value included in a referenced cell is not considered in determining which value is the maximum value.
If there is an even number of values in the set, the MEDIAN function returns the average of the two middle values.
Examples |
|---|
=MEDIAN(1, 2, 3, 4, 5) returns 3. =MEDIAN(1, 2, 3, 4, 5, 6) returns 3.5. =MEDIAN(5, 5, 5, 5, 6) returns 5. |