Description Computes the median or middle value of a list of numbers arranged in ascending order.
Syntax MEDIAN (number_list)
| Argument | Description |
|---|---|
| number_list | A list of between 1 and 30 arguments consisting of numbers, cell references, range references, and/or array constants.All numeric values, including 0, are used. Text and logical values in arrays and cells referenced by this function are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE. |
Remarks If there is an odd number of values in number_list, the middle value is returned. If there is an even number of values, the average of the two middle values is returned.
Example This function returns 3:
This function returns 12:
