MEDIAN function in Excel returns the statistical median (the middle value) of a list of supplied numbers.
Syntax of MEDIAN Function in Excel:
MEDIAN (number1, [number2], …)
- Where the number arguments are a set of one or more numeric values for which you want to calculate the median.
Example of MEDIAN Function in Excel:
Formula:
- When the total number of supplied values are in odd, the median is calculated as the middle number in the group.
- When the total number of supplied values are in even, the median is calculated as the average of the two numbers in the middle.
- Cells containing Text values, logical values, or no value are ignored.