In this article you will learn how to use median function. It can be used for calculating median of given numbers in Excel.

The Median is just the middle value in a set of numbers. But if there is no middle value in the set, median is an average of two middle values.

- MEDIAN of (1, 2, 3, 4, 5) equals 3
- MEDIAN of (1, 2, 3, 4, 5, 6) equals 3.5 which is an average of 3 and 4

The syntax for the MEDIAN function is:

**=MEDIAN(number1, [number2, ...])**

You can use up to 255 numbers in your MEDIAN formula.

## Example 1 Median of an odd number of values

In case of odd number of values, median is just a middle value.

## Example 2 Median of an even number of values

In case of even number of values, median is average of two middle values. Here it is average of 3 and 4, which is 3.5.

## Example 3 Median of selected cells

You can type addresses of cells for which you want to calculate median in Excel.

## Example 4 Median of typed numbers

Instead of addresses you can also use number. Using this methon you don't need any table of data. Notice that formula is not connected with column A in the picture.

## Example 5 Median - mix of above examples

You can also use all above methods together.