MROUND Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

Choose the nearest standardized increment for estimates, measurements and planning. The documented English-language formula is MROUND(number, multiple). All numerical outcomes below are independently derived worksheet expectations, with the official documentation cited for the exact signature and explicit error notes.

Round a numerical value to the nearest multiple, rather than always up or down. For positive values and positive increments, compare the neighbouring integer multiples, then choose the closest. Cases exactly halfway between two multiples are deliberately reserved for a native-version test.

A multiple is not the same thing as a decimal-place count. With 2-unit increments, permitted results are 0, 2, 4, 6, 8 and so on; a request to round to two decimal places is a different calculation. The most important choice is whether your business rule requires an upper boundary, a lower boundary, or the nearest boundary. See the comparison section below before substituting similar function names.

=MROUND(number, multiple)

Documentation-confirmed status: ONLYOFFICE’s MROUND reference identifies this name and argument order. Both named arguments are required; no default is documented.

Meaningful error/domain caution: ONLYOFFICE specifically documents #NUM! when number and multiple have different signs. If you need an exact error string for unmentioned invalid inputs, test the target editor rather than importing a rule from Microsoft Excel or another spreadsheet.

1. Open an empty sheet and use row 1 for column labels. Enter each numeric value from the table below into the indicated B, C cells, without currency symbols or units embedded as text.
2. Keep the scenario labels in A only; labels are explanatory and are not part of the calculation.
3. Enter the formula for row 2 in the indicated formula column, or type each listed row formula verbatim. Use English function names and comma argument separators for this example workbook.
4. Compare the displayed output against the independently expected number. If your regional settings use another separator or translated function name, use the settings-aware form rather than assuming these literal commas work in every locale.
5. Keep raw measurements separate from formatted outputs: changing displayed decimal places does not necessarily change the numeric value used by rounding.

How to check the arithmetic: For row 2, =MROUND(B2,C2) has an independently expected output of 4. Work from the original number and increment rather than the displayed precision. These rows are examples you can enter yourself; none is claimed to have been executed in the ONLYOFFICE app.

Enter these into empty cells on a test sheet (the error demonstrations are the official documented sign-mismatch cases only):

Validation method: For regular numerical cases, the expected outcomes were calculated with Python Decimal arithmetic and matched to the examples without invoking an ONLYOFFICE calculation engine. The MROUND function signature and any explicitly labelled vendor error text were checked against the official page; other platform-specific behaviour remains untested.

Standardize quoted prices and measurements

In a quotation sheet set B12 = 38.2 and C12 = 5. =MROUND(B12,C12) expects 40 as the nearest five-unit price tier; by comparison, =FLOOR(B12,C12) expects 35 and =CEILING(B12,C12) expects 40. At B13 = 36.1, =MROUND(B13,C12) expects 35 while CEILING still expects 40. This shows why nearest and minimum-capacity rounding should not be used interchangeably.

For a 2.37 m reading rounded to nearest quarter meter, =MROUND(2.37,0.25) expects 2.25, while =MROUND(2.39,0.25) expects 2.5. A measurement logger should preserve unrounded raw data for later analysis.

Halfway ties and sign-sensitive inputs

The public MROUND page identifies the arguments and opposite-sign error but does not specify how a halfway tie is chosen or whether a borderline floating-point representation affects the result. Therefore this manuscript does not certify the result of =MROUND(6,4) as a native ONLYOFFICE observation. A same-sign negative case, such as =MROUND(-7,-4), also requires native confirmation before asserting an application-specific guarantee.

If a workbook shows a general formula error, first confirm that the number of arguments, function spelling, argument separator and value types match the target editor’s settings. The short vendor reference does not justify a complete type-coercion/error-code matrix; do not present guessed #VALUE!/#DIV/0! results as ONLYOFFICE-tested facts.

MROUND targets the nearest multiple. The unversioned vendor page does not state a precise halfway-tie convention, so the examples intentionally avoid ties and do not claim observed negative same-sign execution.

Related vendor references (these are separate documented entries, not guaranteed cross-version aliases):

• CEILING official ONLYOFFICE reference — a separate documented function; not an alias for MROUND.
• FLOOR official ONLYOFFICE reference — a separate documented function; not an alias for MROUND.
• CEILING.MATH official ONLYOFFICE reference — a separate documented function; not an alias for MROUND.

• Docs/web documentation: The unversioned English ONLYOFFICE MROUND reference and current Spreadsheet Editor function catalogue list the formula. This establishes a documented function, not a successful calculation in any specific hosted Docs installation.
• ONLYOFFICE Docs release context: The Docs changelog lists version 10.0.0 with a release date of October 10, 2026. It does not, by itself, establish the first build that supported this particular rounding function, or prove that a given server has upgraded.
• ONLYOFFICE Desktop: Desktop Editors has a separate public release history. The available entries do not establish a first-support version for this function. No desktop binary was installed or used; treat Desktop support in historical builds as unverified.
• Regional formula settings: ONLYOFFICE Spreadsheet Editor Advanced Settings documents selectable formula language, region and number separators. The English/comma-based formulas above are the teaching notation, not a locale-independent guarantee. Function names and argument delimiters may require adaptation; there was no localized runtime test.
• Cross-program workbooks: A matching function name in Excel, LibreOffice, Google Sheets or an older OOXML workbook is not evidence that a particular ONLYOFFICE version executes it identically. Especially test negative-value rules, ties, zero significance and existing workbooks in the intended editor/edition.

• ROUND function guide
• ROUNDUP function guide
• ROUNDDOWN function guide

• MROUND function reference — syntax, purpose and explicit notes — checked 2026-10-13 UTC.
• Spreadsheet Editor: Insert functions — catalogue and function-entry procedure — checked 2026-10-13 UTC.
• Spreadsheet Editor: Advanced Settings — formula language and regional formats — checked 2026-10-13 UTC.
• ONLYOFFICE Docs changelog — release context — checked 2026-10-13 UTC.
• ONLYOFFICE DesktopEditors releases — separate platform history — checked 2026-10-13 UTC.

Verification limitations: Direct numerical outputs were independently calculated using an explicit mathematical model. Native Desktop/web execution, invalid-input runtime behavior, historical compatibility and localized formula parsing were not tested.