## Tuesday, April 26, 2022

### MEDIAN function [MS]

Returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less.

## Syntax

MEDIAN(number1,number2,...)

Number1, number2, ...     are 1 to 30 numbers for which you want the median.

## Remarks

• The arguments should be either numbers or column references that contain numbers.

• If a column reference argument contains text, logical values, or is empty, those values are ignored; however, arguments with the value zero are included.

• If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle. See the second formula following.

## Examples

 Col1 Col2 Col3 Col4 Col5 Col6 Formula Description (Result) 1 2 3 4 5 6 =MEDIAN([Col1],[Col2],[Col3],[Col4],[Col5]) Median of the first 5 numbers in the list (3) 1 2 3 4 5 6 =MEDIAN([Col1],[Col2],[Col3],[Col4],[Col5],[Col6]) Median of all the numbers, or the average of 3 and 4 (3.5)