ROUND

Supported, behaves as documented

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

Real, executed compatibility results for the ROUND 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)	Supported, behaves as documented

LibreOffice version history

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

LibreOffice version	Verdict	Tested
24.2.0.3	Supported, behaves as documented	2026-07-19
24.8.7.2	Supported, behaves as documented	2026-07-19
25.2.0.3	Supported, behaves as documented	2026-07-24
25.8.7.3	Supported, behaves as documented	2026-08-06

Executed test cases

LibreOffice Calc 25.8.7.3 (tested 2026-08-06)

Formula	Description	Result	Expected	Verdict
=ROUND(2.5,0)	Excel/LO ROUND uses arithmetic rounding (half away from zero), NOT banker's rounding (round-half-to-even)	3	3 Banker's rounding would give 2; correct spreadsheet behavior is 3	Matched
=ROUND(-2.5,0)	Negative half-values also round away from zero	-3	-3	Matched
=ROUND(12345,-2)	Negative num_digits rounds to the left of the decimal point	12300	12300	Matched
=ROUND(1.005,2)	Tests whether the engine falls into the naive-binary-float trap: the IEEE-754 double closest to 1.005 is actually ~1.00499999999999989, so a naive floor(x*100+0.5)/100 implementation would round DOWN to 1.00	1.01	1.01 Both Excel and LibreOffice correctly return 1.01, not 1.0 -- they normalize to ~15 significant decimal digits before rounding, specifically to avoid this well-known binary-float pitfall	Matched

Docs & syntax

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