MEDIAN function

MEDIAN returns the median (middle) value in the list.

Syntax

MEDIAN(number 1,number 2, ...number 255.)

MEDIAN logically ranks the numbers (lowest to highest). If given an odd number of values, MEDIAN returns the middle value. If given an even number of values, MEDIAN returns the arithmetic average of the two middle values.

Example

=MEDIAN(5,12,65,82,9) returns 12.

=MEDIAN(5,12,65,82,9,78) returns 38.50.