[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
MEDIAN ( argument-list )
Description: Computes the median of the numeric values of its arguments.
Arguments:
|
Name |
Type |
Description |
|
argument-list |
logical, number, name, arrays, reference to number. |
The arguments in argument-list designate the values whose median is to be computed. If there is an even number of numbers in the set, MEDIAN calculates the average of the two numbers in the middle. Logical values and text representations of numbers entered directly into the list of arguments are included. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included. |
Return Type and Value: number – The median of the values of its arguments.
[Example:
MEDIAN(10,20) results in 15
MEDIAN(-3.5,1.4,6.9,-4.5) results in -1.05
MEDIAN({-3.5,1.4,6.9},-4.5) results in -1.05
end example]