← All functions

MODE

Quirk found

Category: Compatibility · 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)	Quirk found

Discovered quirks

=MODE(A1:A4) on LibreOffice Calc returned #VALUE!, but the documented/expected result is #N/A. Microsoft's MODE docs state verbatim: 'If the data set contains no duplicate data points, MODE returns the #N/A error value' -- https://support.microsoft.com/en-us/office/mode-function-e45192ce-9122-4980-82ed-4bdc34973120; MISMATCH vs expected: expected '#N/A', got '#VALUE!'

Executed test cases

LibreOffice Calc 24.2.7.2 (tested 2026-07-04)

Formula	Description	Result	Expected	Verdict
=MODE(A1:A6)	Basic case with one clearly most-frequent value	4	4 This is Microsoft's own documented MODE example data set -- https://support.microsoft.com/en-us/office/mode-function-e45192ce-9122-4980-82ed-4bdc34973120 -- 4 appears 3 times, more than any other value	Matched
=MODE(A1:A4)	When every value in the data set is unique (no duplicates at all), MODE has nothing to return	#VALUE!	#N/A Microsoft's MODE docs state verbatim: 'If the data set contains no duplicate data points, MODE returns the #N/A error value' -- https://support.microsoft.com/en-us/office/mode-function-e45192ce-9122-4980-82ed-4bdc34973120	Mismatch
=MODE(A1:A5)	MODE works the same way on negative numbers	-3	-3	Matched
=MODE(A1:A6)	Text values and blank cells in the range are ignored when finding the mode	1	1 Only the numeric cells 1,1,2,3 participate; 1 is the most frequent among them	Matched

Docs & syntax

Excel: official documentation
Google Sheets: official documentation
LibreOffice Calc: official documentation