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.
Version
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.
MEDIAN formula examples
In order to understand this problem, make sure you understand how percentage number formatting works. In a nutshell, percentages are decimal values: 0.1 is 10%, 0.2 is 20%, and so on. The number 1, when formatted as a...
The MEDIAN function has no built-in way to apply criteria. Given a range, it will return the MEDIAN (middle) number in that range.
To apply criteria, we use the IF function inside MEDIAN to "filter" values. In this...
Related functions
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.
