# MEDIAN

Returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less.

**Syntax**

**MEDIAN**(**number1**,number2, ...)

**Number1**,number2, ... are 1 to 30 numbers for which you want the median.

- The arguments should be either numbers or names, arrays, or references that contain numbers. Microsoft Excel examines all the numbers in each reference or array argument.
- If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

**Remarks**

If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle. See the second example following.

**Examples**

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

equals 3

`MEDIAN(1, 2, 3, 4, 5, 6)`

equals 3.5, the average of 3 and 4