FLOOR: Positive-Input Multiple Rounding in WPS Spreadsheet
Round positive values to next lower step multiples with FLOOR. Follow explicit numeric controls and distinguish direction, precision and documented limits.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
FLOOR rounds a positive number to the next lower multiple of a supplied step. The step is a numeric increment, not a count of decimal places. These examples deliberately use positive numbers and positive steps; they do not generalize negative-sign behavior from another spreadsheet.
Syntax and bounded domain
=FLOOR(number, significance)
Both arguments are supplied. Number is the value to round and significance is the target step. The lesson describes its direction in terms of absolute value. Within the positive-only controls here, this means round downward to the previous step. An exact multiple is unchanged.
A step of 5 means multiples such as 5, 10, 15 and 20. It does not request five digits after the decimal point. A step of 0.1 describes tenths as a numeric grid.
Reproduce the controls
| Formula | Independently expected result |
|---|---|
=FLOOR(12,5) |
10.0 |
=FLOOR(13,5) |
10.0 |
=FLOOR(15,5) |
15.0 |
=FLOOR(5.22,0.1) |
5.2 |
=FLOOR(5.22,1) |
5.0 |
=FLOOR(101,25) |
100.0 |
For 13 with step 5, the surrounding multiples are 10 and 15. FLOOR chooses 10 according to direction, not which is closer. The exact multiple 15 stays 15. For the lesson’s positive decimal control 5.22, step 0.1 gives 5.2, while step 1 gives 5.
Practical case: complete units from available capacity
Suppose 101 units are available and allocation must be made in increments of 25. The corresponding positive-input result is 100. That represents four complete batches and leaves 1 unit unallocated. These are independent integer calculations, not recommendations about purchasing or spending.
The choice of direction expresses the model’s constraint. Rounding down can avoid exceeding available capacity but may understate a requirement if used indiscriminately. MROUND instead chooses the nearest multiple and serves a different policy.
Errors, signs and numerical caution
The lesson documents #VALUE! for nonnumeric arguments and #NUM! for opposite signs. Those are attributed historical documentation statements, not newly observed runtime errors or proof of all current-version sign handling. The worked calculations stay within positive inputs and positive nonzero steps. Zero-step and broader negative-sign behavior are not generalized.
The examples use small values with clear grid positions. They do not establish precision or overflow guarantees for extreme magnitudes or values extremely close to a multiple. A displayed decimal can conceal a different stored binary value. Keep the intended unit and step visible, and distinguish a mathematically exact control from a runtime precision test.
No optional mode or default step is assumed. Supply both arguments explicitly. Similar names in other spreadsheet products are not sufficient evidence of identical legacy rounding contracts.
Availability and evidence
The official WPS lesson is dated 2019-06-12 and explicitly labels its applicability WPS Office for Windows Personal. It does not identify a numeric release. This establishes documentation by that date, not the function’s original introduction or its last working version. Current build limits and equivalence across WPS clients remain unverified. The available evidence does not establish retirement or formal deprecation.
Checked October 18, 2026. The examples in this guide are original, independently calculated controls based on the lesson. They have not been run in WPS or another spreadsheet application. No screenshot or execution result is claimed.