FLOOR Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples
Reduce a positive measurement to the largest whole increment that does not exceed it. Learn the documented ONLYOFFICE signature with a reproducible worksheet, real applications, troubleshooting and compatibility cautions.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
FLOOR rounds a positive quantity down to a chosen positive increment. For example, =FLOOR(8,3) gives 6, the largest three-unit multiple that does not exceed 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 reference. Documentation check; not a new native test.
What FLOOR does
Round down to an increment using the documented legacy sign restriction. For positive values, find the greatest multiple of the positive step that does not exceed the original quantity.
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.
Exact ONLYOFFICE syntax and arguments
=FLOOR(number, significance)
| Argument | Required | Type | Default | Meaning |
|---|---|---|---|---|
number |
Yes | Numeric value or cell reference | — | Value to round. |
significance |
Yes | Numeric increment or cell reference | — | Size of each permitted interval. |
Both arguments are required; the reference does not document an omitted default.
Meaningful error/domain caution: The vendor states #NUM! if the input value and significance have different signs (the note calls the first argument x; the syntax calls it number). 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.
Build a sample worksheet
In a blank sheet, put labels in A1:D1 for Scenario, Number, Increment and Result. Enter columns A:C below, then =FLOOR(B2,C2) in D2 and fill to D7. The Expected value column is for comparison, not another input.
| Row | A: Scenario | B: Number | C: Increment | D: Formula | Expected value |
|---|---|---|---|---|---|
| 2 | Two-unit blocks | 4.1 | 2 | =FLOOR(B2,C2) |
4 |
| 3 | Cable spool | 8 | 3 | =FLOOR(B3,C3) |
6 |
| 4 | Shelving units | 12 | 5 | =FLOOR(B4,C4) |
10 |
| 5 | Aligned length | 12 | 4 | =FLOOR(B5,C5) |
12 |
| 6 | Trim strips | 3.2 | 0.5 | =FLOOR(B6,C6) |
3 |
| 7 | Sample aliquots | 7.7 | 0.25 | =FLOOR(B7,C7) |
7.5 |
For row 2, 4 is the greatest two-unit multiple below 4.1. With positive inputs, divide by the increment, take the integer part and multiply back.
Opposite signs are a documented error
Both =FLOOR(5,-2) and =FLOOR(-5,2) have the vendor-documented expected result #NUM!. The reference calls the first argument x in this note; it means the number argument in the signature. Do not import a different product’s negative-input rules solely because its function name matches.
Advanced use in real worksheets
Full cartons versus leftover units
Let B12 = 37 units and C12 = 8 units per carton. =FLOOR(B12,C12) expects 32 units that fit into complete cartons. =FLOOR(B12,C12)/C12 expects 4 full cartons. The leftover expression =B12-FLOOR(B12,C12) expects 5 units; alternatively check against the documented MOD function with =MOD(B12,C12). This is often more useful than returning only the rounded-down quantity.
Cutting stock versus inventory commitments
For a 10.9 m material length sold in whole 2.5 m pieces, =FLOOR(10.9,2.5) expects 10 m of complete pieces, which is 4 pieces. Do not use FLOOR to determine how much must be purchased to cover a requirement; that needs an upward rounding policy.
Negative quantities and decimal boundaries
The short reference does not fully specify same-sign negative inputs or zero significance. These examples therefore use positive increments and positive measurements. Inspect underlying values around decimal boundaries, rather than relying on the displayed precision.
Common problems and troubleshooting
| Symptom or question | Likely issue | Practical check or correction |
|---|---|---|
#NUM! |
Number and significance have opposite signs. | Choose a sign-compatible approach or inspect the MATH variant, which has different rules. |
| Too few cartons | The formula gives rounded units, not automatically a count. | Divide the rounded quantity by carton size. |
| Under-allocation | Rounding down discards a partial increment. | Use CEILING for minimum capacity needed. |
| Unexpected negative result | Legacy negative-input direction cannot be inferred from the word “down” alone. | Test the exact case and editor version natively. |
| Blank, text or zero significance | The vendor page does not provide all error strings. | Validate inputs before using production formulas. |
Use numeric input cells and check the configured formula language if a formula is rejected. Undocumented text/blank coercion and error tokens are not assumed here.
Compare closely named functions without conflating them
Unlike FLOOR.MATH or FLOOR.PRECISE, legacy FLOOR documents an opposite-sign #NUM! condition and requires the significance. Its negative/same-sign and zero behaviour should not be asserted solely from the unversioned help entry.
Related vendor references (these are separate documented entries, not guaranteed cross-version aliases):
- FLOOR.MATH official ONLYOFFICE reference — a separate documented function; not an alias for FLOOR.
- FLOOR.PRECISE official ONLYOFFICE reference — a separate documented function; not an alias for FLOOR.
- CEILING official ONLYOFFICE reference — a separate documented function; not an alias for FLOOR.
- MROUND official ONLYOFFICE reference — a separate documented function; not an alias for FLOOR.
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. No examples were executed in ONLYOFFICE.