# Excel MEDIAN Function

Summary

The MEDIAN function returns the median (middle number) in a group of supplied numbers. For example, =MEDIAN(1,2,3,4,5) returns 3.

Purpose

Get the median of a group of numbers

Return value

A number representing the median.

Syntax

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

Arguments

**number1**- A number or cell reference that refers to numeric values.**number2**- [optional] A number or cell reference that refers to numeric values.

Usage notes

- When the total number of supplied numbers is odd, the median is calculated as the middle number in the group.
- When the total number of supplied numbers is even, the median is calculated as the average of the two numbers in the middle.
- Cells that contain text, logical values, or no value are ignored.
**Numbers**can be supplied as numbers, ranges, named ranges, or cell references that contain numeric values. Up to 255**numbers**can be supplied.