MEDIAN Function Explained
The MEDIAN function in Microsoft Excel returns the median of a set of numbers. It takes up to 255 arguments, which can be numbers, cell references, or ranges. It ignores logical values and text. The median is the middle number in a set of numbers, and is useful for finding the average of a set of numbers that may have outliers.
MEDIAN Function Syntax
MEDIAN(number1, [number2], ...)
number1: The first number or range of numbers for which you want the median.number2: (optional) Additional numbers or ranges of numbers for which you want the median.