MEDIAN function
Summary
Returns the median of the given numbers
Syntax
MEDIAN(number1, [number2], ...)
The MEDIAN function syntax has the following arguments:
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want the median.
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want the median.
Example
=MEDIAN(A2:A6)
=MEDIAN(A2:A7)
=MEDIAN(A2:A7)