ROUND
Supported, behaves as documentedCategory: Math and trigonometry · 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 |
|---|---|---|---|---|
| =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