FLOOR.MATH Function in ONLYOFFICE Spreadsheet Editor: Syntax and Worked Examples
Round down to multiples while using an optional mode to control the direction for negative numbers. Includes documented syntax, a reproducible worksheet, error caveats, signed examples and release-specific cautions.
Verification status: Two specified negative-number mode cases were checked in ONLYOFFICE Desktop Editors Community 10.0.0.169 on Linux. Zero significance, coercion and other examples were not covered by those native tests. How formula examples are checked
FLOOR.MATH rounds down to a multiple, with a mode for negative values. =FLOOR.MATH(-11.3,4) gives -12, while =FLOOR.MATH(-11.3,4,1) gives -8.
Availability and version history
- Introduced: The original introduction release and date are not established by the official sources checked.
- Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
- Scope: Docs and Desktop Editors release separately. The unversioned function reference does not establish support in every older or mobile build.
- Checked: October 14, 2026, against the official FLOOR.MATH reference. Documentation and independent examples, plus the two Desktop Editors Community 10.0.0.169 Linux mode checks below.
What FLOOR.MATH does, and when to use it
Express downward increments for capacities, thresholds, or signed adjustments while deliberately choosing how negative numbers are treated. Mode is a calculation rule, not an optional display format.
The default mode=0 turns −11.3 into −12 at a four-unit step; nonzero mode turns it into −8. That four-unit difference can change a refund, inventory correction, or deviation threshold. Unlike ROUND(number,num_digits), which uses decimal places, FLOOR.MATH uses a multiple. For a step of 0.25, possible results lie on a quarter-unit grid; for a step of 8, possible results lie on an eight-unit grid. Do not confuse an increment with the number of decimal places displayed in the spreadsheet.
Official syntax and argument order
=FLOOR.MATH(number, [significance], [mode])
| Argument | Required? | Data type | Default | What it means |
|---|---|---|---|---|
number |
Yes | Number or a cell containing a numeric value | — | The signed quantity to round. |
significance |
No | Numeric multiple/increment | 1 |
The size of the increment. Omitted means whole-unit multiples. |
mode |
No | Numeric: 0 or any other numeric value | 0 |
Controls how negative inputs are rounded: 0 or omitted away from zero, nonzero toward zero. For positive inputs it has no effect. |
Square brackets in the help page denote optional arguments; do not type literal square brackets in the formula. For ordinary examples, use explicit numeric cells and a positive significance. The help article does not establish a complete type-coercion policy for blank/text/booleans or all negative significance values.
Zero significance: The short reference does not specify its outcome. Use a positive increment for the examples below.
Reproduce the worksheet
In a blank sheet, label A:E for Scenario, Number, Step, Mode and Result in row 1. Enter the numeric inputs and scenario labels below. Put =FLOOR.MATH(B2,C2,D2) in E2, then fill down through row 9. The expected output is for comparison, not an input column.
| Row | Scenario (A) | Number (B) | Step (C) | Mode (D) | Formula | Independent expected output |
|---|---|---|---|---|---|---|
| 2 | Positive stock multiple | 11.3 | 4 | 0 | =FLOOR.MATH(B2,C2,D2) |
8 |
| 3 | Default negative adjustment | -11.3 | 4 | 0 | =FLOOR.MATH(B3,C3,D3) |
-12 |
| 4 | Negative mode override | -11.3 | 4 | 1 | =FLOOR.MATH(B4,C4,D4) |
-8 |
| 5 | Already aligned | 12 | 4 | 0 | =FLOOR.MATH(B5,C5,D5) |
12 |
| 6 | Quarter unit | 7.7 | 0.25 | 0 | =FLOOR.MATH(B6,C6,D6) |
7.5 |
| 7 | Signed fractional, default | -3.1 | 0.5 | 0 | =FLOOR.MATH(B7,C7,D7) |
-3.5 |
| 8 | Signed fractional, alternate | -3.1 | 0.5 | 7 | =FLOOR.MATH(B8,C8,D8) |
-3 |
| 9 | Zero input | 0 | 2 | 0 | =FLOOR.MATH(B9,C9,D9) |
0 |
How the numbers were derived: For a negative input with mode zero, round the quotient down (e.g., −4.1/2 = −2.05 to −3), then multiply by the increment. With nonzero mode, round the negative quotient up toward zero (−2.05 to −2). Positive inputs are rounded down regardless of mode. Keep full precision in the calculation and use cell formatting only for display.
Defaults and special cases
| Formula | Expected result |
|---|---|
=FLOOR.MATH(4.1) |
4 |
=FLOOR.MATH(-4.1) |
-5 |
=FLOOR.MATH(-4.1,2,-3) |
-4 |
=FLOOR.MATH(4.1,2,7) |
4 |
Two native negative-mode checks
In Desktop Editors Community 10.0.0.169 on Linux, =FLOOR.MATH(-5.5,2) returned -6, while =FLOOR.MATH(-5.5,2,1) returned -4. These exact formulas confirm the default-versus-mode-1 direction for this negative input and positive step. They do not establish the untested zero-significance or coercion cases.
Advanced applications: the business rule matters
Storage bin fill count
B12 = 37 packed items and C12 = 8 items per full bin. Enter =FLOOR.MATH(B12/C12) in an empty result cell. The independently expected output is 4. Only four complete bins can be filled; five bins require at least 40 items. The division is intentional: FLOOR.MATH rounds the number of bins rather than the count of items.
Negative stock adjustment with policy mode
B13 = −11.3 units, C13 = 4-unit step, D13 = 1 means toward zero. The formula =FLOOR.MATH(B13,C13,D13) has an independently expected output of -8. If the policy instead uses mode 0, the expected result is −12. Put the mode in a clearly labelled column so audits can reproduce the choice.
Avoid rounding the wrong unit
If a worksheet holds individual items but a team wants full cartons, decide whether to round items to carton-sized increments or round carton counts to whole numbers. For example, rounding 37 items to a multiple of 8 produces a number of items; rounding 37/8 to a whole number produces a number of cartons. The two numeric outputs use different units. Label your result column accordingly.
How to troubleshoot FLOOR.MATH
| Observation | Likely explanation | Practical verification |
|---|---|---|
| A negative result is lower than expected | The default mode 0 rounds away from zero. | Test =FLOOR.MATH(-11.3,4,0) and compare to mode 1. |
| Nonzero mode changes positive outputs | Vendor says mode has no effect on positive inputs. | Check sign and ensure mode is in the third argument. |
| Zero significance or text passed | The official article does not establish this error/output matrix. | Validate numeric input and use a test workbook for your installed build. |
| An English name or comma does not parse | Formula language or workbook/editor settings differ from this teaching notation. | Inspect File → Advanced Settings → Regional settings; check names and delimiters for this edition. |
| A pasted value is text | The value may include embedded units, an apostrophe, or an unexpected decimal format. | Put a plain number in a test cell and reference that cell; inspect the editor’s real error before naming it. |
| Rounding a tiny decimal gives odd displayed digits | Binary floating-point storage or formatting can affect presentation in a real engine. | Compare full numeric results, not only rounded display text, and verify boundary cases in the intended build. |
Use numeric cells and do not infer undocumented coercion or error tokens from another spreadsheet.
Which similar function should you choose?
Legacy FLOOR documents an opposite-sign #NUM! case, while FLOOR.MATH allows a negative input with a positive increment and a mode argument. FLOOR.PRECISE does not take mode; replacing one with another can change signed adjustments.
- FLOOR — official function reference — separately documented function name; compare the full argument list before substituting.
- FLOOR.PRECISE — official function reference — separately documented function name; compare the full argument list before substituting.
- CEILING.MATH — official function reference — separately documented function name; compare the full argument list before substituting.
- CEILING.PRECISE — official function reference — separately documented function name; compare the full argument list before substituting.
Related guides and formula entry
- MOD calculates a remainder.
- INT rounds to an integer.
- ROUNDDOWN uses a decimal-place count rather than an increment.
The function-entry guide explains the function dialog. Examples use English names, commas and decimal points; check Advanced Settings for formula language and regional formatting.
Example verification: Numerical expectations were checked with independent decimal and rational arithmetic. Explicit special cases and errors come from the cited function reference. The two named native mode checks were executed in Desktop Editors Community 10.0.0.169; the remaining worksheet outputs are independent expectations.