MEDIAN(n1,n2,...)
- Where n1,n2… are numerical values.
MEDIAN() calculates the middle value in the set of given values.
Description
MEDIAN(n1,n2,...)
For Example,
MEDIAN(10,30,50,70,90) returns 50.
MEDIAN(2,4,6,8) returns 5.
MEDIAN("TEST","TEN","TAKE","TELL","TRAIN") returns TAKE.
- Arguments can be numbers or arrays, names or references that contain numbers.
- For a set of even numbers, MEDIAN calculates the average of the two numbers that are in the middle.
- If the logical values and text representations are entered as a part of argument, they are counted.
- If the logical values and text representations are entered as a part of an array or reference, they are not counted.
- The cells with zero value are counted.
Examples
| 45 | 2 | ||
| -20 | 4 | ||
| -30 | TRUE | ||
| 4 | 0.5 | ||
| 5 |
=MEDIAN(A1:A5) =MEDIAN(A1:A5) =MEDIAN(A1:A5)