Skip to main content

MEDIAN

Returns the median (middle value) of the given numbers. If there is an even number of values, returns the average of the two middle values.

CategoryStatistical
SyntaxMEDIAN(number1, [number2], ...)

Parameters

ParameterRequiredDescription
number1RequiredThe first number, cell reference, or range.
number2OptionalAdditional numbers, cell references, or ranges.

Example

MEDIAN(1, 3, 5)       // → 3

Auto-generated from the EngCanvas function registry.