value…: Optionally include one or more additional values or collections.
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.