MROUND
Quirk foundCategory: 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) | Quirk found |
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 24.2.7.2 (tested 2026-07-04)
| 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 |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
- LibreOffice Calc: official documentation