FLOOR.PRECISE Function in ONLYOFFICE Spreadsheet Editor: Syntax and Worked Examples
Round toward a lower multiple with a predictable signed-number rule and an optional significance. Includes documented syntax, a reproducible worksheet, error caveats, signed examples and release-specific cautions.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
FLOOR.PRECISE rounds down along the number line: =FLOOR.PRECISE(-4.1,2) gives -6. It uses a multiple rather than a decimal-place count and has no direction-mode argument.
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.PRECISE reference. Documentation check; not a new native test.
What FLOOR.PRECISE does, and when to use it
Choose the greatest allowed increment-aligned result not above the original input. It is useful for conservative capacity and floor thresholds, but negative inputs require attention: the next lower result has greater absolute magnitude.
For a measurement of −4.1 with two-unit increments, the lower permitted result is −6. If your goal is moving a negative value toward zero, use a mode-aware rule rather than calling −4 “down”. Unlike ROUND(number,num_digits), which uses decimal places, FLOOR.PRECISE 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.PRECISE(number, [significance])
| 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. |
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 official reference explicitly returns 0 for a zero increment. This is a documented special case, not a rounding calculation based on division by zero.
Reproduce the worksheet
In a blank sheet, label A:D for Scenario, Number, Step and Result in row 1. Enter the numeric inputs and scenario labels below. Put =FLOOR.PRECISE(B2,C2) in D2, then fill down through row 9. The expected output is for comparison, not an input column.
| Row | Scenario (A) | Number (B) | Step (C) | Formula | Independent expected output |
|---|---|---|---|---|---|
| 2 | Complete-case units | 11.3 | 4 | =FLOOR.PRECISE(B2,C2) |
8 |
| 3 | Negative signed correction | -11.3 | 4 | =FLOOR.PRECISE(B3,C3) |
-12 |
| 4 | Aligned value | 12 | 4 | =FLOOR.PRECISE(B4,C4) |
12 |
| 5 | Quarter unit | 7.7 | 0.25 | =FLOOR.PRECISE(B5,C5) |
7.5 |
| 6 | Negative half unit | -3.1 | 0.5 | =FLOOR.PRECISE(B6,C6) |
-3.5 |
| 7 | Tiny positive | 0.1 | 0.2 | =FLOOR.PRECISE(B7,C7) |
0 |
| 8 | Tiny negative | -0.1 | 0.2 | =FLOOR.PRECISE(B8,C8) |
-0.2 |
| 9 | Zero input | 0 | 2 | =FLOOR.PRECISE(B9,C9) |
0 |
How the numbers were derived: Divide by a positive increment, take the mathematical floor of the quotient, and multiply by the increment. For a negative quotient, mathematical floor moves farther from zero. For significance zero, use ONLYOFFICE’s explicitly documented zero output. Keep full precision in the calculation and use cell formatting only for display.
Defaults and special cases
| Formula | Expected result |
|---|---|
=FLOOR.PRECISE(4.1) |
4 |
=FLOOR.PRECISE(-4.1) |
-5 |
=FLOOR.PRECISE(9,0) |
0 |
=FLOOR.PRECISE(-9,0) |
0 |
Advanced applications: the business rule matters
Full packing trays
B12 = 37 pieces and C12 = 8 pieces per tray. Enter =FLOOR.PRECISE(B12/C12) in an empty result cell. The independently expected output is 4. Only four full trays can be packed. Remaining five pieces do not form another complete tray.
Signed lower alarm threshold
B13 = −3.1 °C and C13 = 0.5 °C step. The formula =FLOOR.PRECISE(B13,C13) has an independently expected output of -3.5. Use a half-degree lower bound for displaying a signed sensor threshold. This is an illustrative calculation, not a measurement-error analysis.
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.PRECISE
| Observation | Likely explanation | Practical verification |
|---|---|---|
| Negative number is more negative after rounding | Downward means toward negative infinity. | Check -3.1 against -3.5 and -3.0 on the number line. |
| Third argument rejected | FLOOR.PRECISE documents only number and optional significance. | Use FLOOR.MATH when you require mode. |
| Zero increment unexpectedly returns zero | Official reference explicitly documents zero significance as zero output. | Validate increment cells to prevent accidental zero results. |
| 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?
FLOOR.PRECISE is documented separately from legacy FLOOR and from FLOOR.MATH. The latter accepts mode and can treat negative numbers differently; do not silently swap function names when maintaining audits.
- FLOOR — official function reference — separately documented function name; compare the full argument list before substituting.
- FLOOR.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.
- ISO.CEILING — 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. No examples were executed in ONLYOFFICE.