MEDIAN

Description

The MEDIAN function finds the median value in a set of numbers. The median is the “middle” value in the sense that half the numbers in the set are less than the median and half are greater.

Syntax

MEDIAN(number, [number, . . . ])

• number: A series of numbers, numeric expressions, or references to cells containing numbers or numeric expressions.

Note: If there is an even number of values in the set, the MEDIAN function returns the average of the two middle values.

Examples