Loading…
Loading…
MEDIAN returns the middle value of a set. Unlike the average it is not pulled around by extreme values, which makes it the better "typical" number for salaries or house prices. With an even count it averages the two middle values.
Syntax
MEDIAN(number1, [number2], …)
Example: =MEDIAN(B2:B6) returns the middle salary.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.