MEDIAN Function in Excel
Beginner
Returns the median (middle value) of a set of numbers.
Syntax
=MEDIAN(number1, [number2], ...)Example
Use Case
Find the median salary in a company to understand typical compensation.
Common Errors to Avoid
- Result differs from AVERAGE - median is middle value, not arithmetic mean
- Even number of values returns average of two middle values
- Ignores text and logical values (use MEDIAN.IF for conditional median)
Pro Tips
Use MEDIAN instead of AVERAGE when outliers might skew results (e.g., salary data, real estate prices). Combine with QUARTILE for deeper statistical analysis. MEDIAN is less affected by extreme values than AVERAGE.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →