ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / STATISTICAL

MEDIAN Excel function

Returns the middle value.

Correct sentence to use

Find the median of [range].

Modify this query in PlainFormula →

Example formula

=MEDIAN(A2:A25)

Returns the middle value in a data set.

Syntax

MEDIAN(number1, [number2], …)

Argument signature: number1, [number2], …

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions