MEDIAN Function in Excel

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:

MEDIAN function in Excel 1

  • 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.
Result

MEDIAN function in Excel 2

previous-small MEDIAN Function in Excel                                                                                                           next_small MEDIAN Function in Excel