MEDIAN

Syntax:

MEDIAN(list)

Returns the median value in the list.

list may be an array, a range of cells, or a comma-separated list of values.

If there is an even number of entries in the list, the mean of the two middle values is returned.

It is not assumed that the data is sorted.

Revisions:

Starting with 2.00, this function will accept a list of parameters. Before this, it only accepted an array of data.