<< Click to Display Table of Contents >> MEDIAN (Median)

Syntax:

MEDIAN(Number1 [, Number2, Number3 ...])

Description:

This returns the median of the given set of numbers.

The median is the number in the middle of a set of numbers. Half of the numbers are smaller than the median, while the other half are larger.

Number1, Number2, etc., are single values, cell ranges or arrays that contain the values to be evaluated.

If this function refers to empty cells, they are ignored. Likewise, cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus taken into account.

Note:

If the total number of values is odd, MEDIAN returns the number in the middle of the set of numbers.

If the total number of values is even, MEDIAN returns the average of the two numbers in the middle (see second example).

Example:

MEDIAN(1, 2, 3, 4, 5) returns 3

MEDIAN(1, 2, 3, 4, 5, 1000) returns 3.5

See also:

AVERAGE, MODE.SNGL/MODE, PERCENTILE.EXC/PERCENTILE.INC/PERCENTILE