MROUND

Quirk found

Category: Math and trigonometry · Last tested 2026-08-06

Real, executed compatibility results for the MROUND function across Microsoft Excel, Google Sheets, and LibreOffice Calc — verified by actually running it. Syntax and links to each vendor’s official documentation are below.

Support matrix

Engine	Documented	Live-tested	Verdict
Excel	Yes	Not yet	n/a
Google Sheets	Yes	Not yet	n/a
LibreOffice Calc	Yes	Yes (25.8.7.3, 2026-08-06)	Quirk found

LibreOffice version history

We executed the same test cases under each LibreOffice release to show exactly when MROUND’s support changed — not documentation claims, real results.

LibreOffice version	Verdict	Tested
24.2.0.3	Quirk found	2026-07-19
24.8.7.2	Quirk found	2026-07-19
25.2.0.3	Quirk found	2026-07-24
25.8.7.3	Quirk found	2026-08-06

Why isn't MROUND working in LibreOffice?

MROUND exists in LibreOffice 25.8.7.3, but it is not a drop-in match for Excel — our executed tests found real behavioral differences (detailed in the test results on this page). If a formula that works in Excel or Google Sheets misbehaves in LibreOffice, compare your usage against the failing cases above before assuming your data is wrong.

Discovered quirks

=MROUND(5,-2) on LibreOffice Calc returned 6, but the documented/expected result is #NUM!. MISMATCH vs expected: expected '#NUM!', got 6

Executed test cases

LibreOffice Calc 25.8.7.3 (tested 2026-08-06)

Formula	Description	Result	Expected	Verdict
=MROUND(10,3)	Rounds 10 to the nearest multiple of 3. Source: https://support.microsoft.com/en-us/office/mround-function-c299c3b0-15a5-426d-aa4b-d2d5b3baf427 (worked example)	9	9	Matched
=MROUND(-10,-3)	Both arguments negative (same sign, as required) -> rounds to nearest multiple, sign preserved. Source: Microsoft MROUND docs worked example.	-9	-9	Matched
=MROUND(1.3,0.2)	Rounds 1.3 to the nearest multiple of the fractional value 0.2. Source: Microsoft MROUND docs worked example.	1.4	1.4000000000000001 Microsoft's documented example rounds this to 1.4; true IEEE-754 double nearest value is 1.4000000000000001 (0.2*7), same well-known binary-float representation issue as ROUND(1.005,2) elsewhere in this corpus.	Matched
=MROUND(5,-2)	Number and multiple must have the same sign, per Microsoft docs: 'The Number and Multiple arguments must have the same sign. If not, a #NUM error is returned.'	6	#NUM!	Mismatch
=MROUND(0,5)	Zero rounds to zero regardless of the multiple.	0	0	Matched