MEDIAN
Supported, behaves as documentedCategory: Statistical · Last tested 2026-07-04
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel | Yes | Not yet | n/a |
| Google Sheets | Yes | Not yet | n/a |
| LibreOffice Calc | Yes | Yes (24.2.7.2, 2026-07-04) | Supported, behaves as documented |
Executed test cases
LibreOffice Calc 24.2.7.2 (tested 2026-07-04)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =MEDIAN(A1:A5) | With an odd count of numbers, MEDIAN is the single middle value once sorted | 5 | 5 Sorted: 1,3,5,7,9 -> middle value is 5 |
Matched |
| =MEDIAN(A1:A4) | With an even count of numbers, MEDIAN averages the two middle values | 2.5 | 2.5 Sorted: 1,2,3,4 -> middle two are 2 and 3 -> average 2.5 |
Matched |
| =MEDIAN(A1:A5) | Text values and blank cells in a range argument are ignored (not counted as 0 and not counted toward the element count) | 20 | 20 Only 10, 20, 30 are numeric -> odd count of 3 -> middle value is 20; if blanks/text counted as 0 this would shift the median |
Matched |
| =MEDIAN(A1) | Degenerate single-value case returns that value | 42 | 42 | Matched |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
- LibreOffice Calc: official documentation