ExcelHeroThe MEDIAN function
Returns the middle value.
How to write it
=MEDIAN(number1, [number2], …)- number1
- A range.
💡 Less affected by one huge outlier than AVERAGE.
Try it
What is the median salary?
A
B
C
D
1
Name
Team
Salary
Years
2
Nora
Sales
52000
3
3
Omar
Support
41000
1
4
Priya
Sales
61000
6
5
Quinn
Tech
72000
4
6
Rosa
Support
39000
2
7
Sven
Tech
80000
8
8
Median
The middle value when sorted.