You’ll learn how to use the median function. It can be used to calculate the median of given numbers in Excel.

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

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

Table of Contents

## Syntax of Median function

The syntax for the MEDIAN function is:

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

**Number 1:** This is required.

**Number 2 – 255:** This is optional, going all the way to 255, for which the user wants the median of.

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

## Examples of Median function

Here are some examples of how to use the MEDIAN function in Excel:

### Median of an odd number of values

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

### Median of an even number of values

For an even number of values, the median is the mean of the two middle values. Here it is average of 3 and 4, which is 3.5.

### Median of selected cells

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

### Median of typed numbers

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

### Median – mix of above examples

You can also use all above methods together.