The Excel MEDIAN function returns the statistical median (the middle value) of a list of supplied numbers.
The syntax of the function is:
where the number arguments are a set of one or more numeric values (or arrays of numeric values), for which you want to calculate the median
Also note that in current versions of Excel (Excel 2007 & later), you can provide up to 255 number arguments to the Median function, but in Excel 2003, the function can only accept up to 30 number arguments.
The following spreadsheet shows three examples of the Median function:
Note that, in the above examples:
Further details of the Excel Median function are provided on the Microsoft Office website.