MEDIAN()
Syntax. MEDIAN(number1,number2,...)
Definition. The median is the number in the middle of a set of numbers. This means that half of the numbers have values that are greater than the median, and half of the numbers have values that are smaller than the median. Therefore, the number of the median within a sorted data set equals half of the elements.
Arguments
number1 (required) and number2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to calculate the median.
Note
Arguments can be numbers, names, arrays, or references containing numbers. All numbers associated with a reference or array argument are evaluated. If an array or reference argument contains text, logical values, or empty ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
