MEDIAN Function Generator
MEDIAN returns the middle value when a range is sorted. More robust than AVERAGE when data has outliers (e.g., salaries, response times).
Syntax
=MEDIAN(number1, [number2, ...])Try it — generate a MEDIAN formula
Examples
Median salary
=MEDIAN(A2:A100)Middle salary — unaffected by one CEO making millions.
Median by group
=MEDIAN(IF(B:B="Engineering", A:A))Array formula — Ctrl+Shift+Enter in older Excel.
p50 latency
=MEDIAN(A2:A10000)The 50th percentile of response times.
Tips
- ✓Ignores text and empty cells.
- ✓For even count of values, returns the average of the two middle values.
- ✓Less biased than AVERAGE for skewed data.
Related Formulas
PERCENTILE
PERCENTILE returns the Kth percentile of a data range. Common in performance (p9...
STDEV
STDEV calculates the standard deviation of a data set — how spread out values ar...
RANK
RANK returns the position of a value within a range when sorted. Use RANK.EQ for...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free