MEDIAN (Primitive Spread Function) returns the number in the middle of the provided set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less than the median.
SYNTAX:
MEDIAN(value1,value2,...)
REMARKS:
Accepts up to 30 arguments. Each argument can be a cell or cell range, a float value, or an integer value. If there are an even number of arguments, the function calculates the average of the two numbers in the middle.
EXAMPLES:
MEDIAN(A3,B5,C1,D4,E7)
MEDIAN(A1:A9)
MEDIAN(89,95,76,88,92)=89