Contact
12 programs
Explore the site

FLOOR in Calligra Sheets: Round Down to a Multiple

Mathematics Beginner Calligra Sheets

Use FLOOR in Calligra Sheets to round values to a multiple, interpret negative numbers and mode, and handle significance and source-backed errors.

Verification status: Consult the documentation and examples below. Native application testing has not been documented for this guide. How formula examples are checked

Quick answer: For positive values, FLOOR rounds down to a requested multiple: =FLOOR(5;2) is expected to return 4. With negative numbers, the distinction between toward negative infinity and toward zero matters: =FLOOR(-6.43;-4;0) is expected to return -8, while =FLOOR(-6.43;-4;1) is expected to return -4. KDE’s release-pinned C++ source identifies these paths, but these values have not been tested by executing Calligra Sheets. KDE FLOOR reference · Pinned implementation.

FLOOR is useful for complete production units, whole kits, full-sized cuts and other cases in which a positive total must not exceed a limit. If you must obtain at least the requested positive capacity, you ordinarily want the different CEILING behavior; do not confuse rounding down to a multiple with rounding to the nearest multiple.

Exact syntax, argument types and defaults

=FLOOR(number; [significance]; [mode])

The brackets indicate optional arguments in this explanatory signature; do not type them. The KDE function handbook shows abbreviated syntax FLOOR(x) but describes a second and third argument. The pinned 26.08.2 registration permits one through three arguments. The XML explicitly marks Significance and Mode optional, and the implementation supplies their defaults. KDE handbook · Registration · XML definition.

Position Argument Input and requirement Meaning in the inspected 26.08.2 code
1 number / x Required numeric value, expression or cell reference Starting value; cannot be omitted.
2 significance Optional numeric increment Defaults to +1 for nonnegative values and -1 for negative values; if explicitly nonzero, its sign must agree with the sign of number.
3 mode Optional numeric zero/nonzero switch Omitted or 0 rounds negative results toward negative infinity; nonzero rounds negative results toward zero. The difference disappears for positive inputs.

The XML lists floating-point arguments, even though its <Type>Integer</Type> return annotation and shortened FLOOR(x) help are misleading for fractional multiples. The same handbook gives FLOOR(5;2.2) = 4.4, and the source returns Value(result) after multiplying by significance. Therefore a fractional numeric result is a documented, source-supported expectation, not a reason to coerce the answer to an integer. KDE examples · XML and C++.

Use semicolons here because KDE’s English formula examples use them. An installed locale may have a different decimal mark or formula argument separator; the alternatives are not independently verified in a native application. Consult the application’s Function dialog for local formula syntax before entering formulas in another locale.

Reproducible worksheet: complete multiples

Create a sheet. Enter these labels in row 1: A1 Scenario, B1 Number, C1 Significance, D1 Mode, E1 Result. Set B–D numeric. Enter the following table; the rightmost numbers are independent/source-derived expectations, not captured application outputs.

Row A: Scenario B: Number C: Significance D: Mode E: Expected result
2 Complete double units 5 2 0 4
3 Fractional increment 5 2.2 0 4.4
4 Negative, default mode -6.43 -4 0 -8
5 Negative, toward zero -6.43 -4 1 -4
6 Full-length stock pieces 127 12 0 120
7 Already an exact multiple 8 4 0 8
  1. Select E2 and enter =FLOOR(B2;C2;D2). An independent numerical calculation gives 4.
  2. Copy or fill E2 downward to E7, allowing the relative references to change automatically. E3 is expected to be 4.4, demonstrating that the increment need not be an integer.
  3. Compare E4 and E5. Only the mode changes: the values are -8 and -4, respectively. Negative-number rounding must be interpreted with care.
  4. Check E6. It should represent 120 complete measurement units inside a 127-unit positive total.
  5. Check E7. An already exact multiple stays at 8, rather than moving to the next lower multiple.
  6. Try =FLOOR(12.5) in a separate empty cell (expected 12) and =FLOOR(-12.5) (expected -13). These are explicit handbook examples, not measured native outputs.

The English handbook documents all basic rounding directions; the 26.08.2 implementation explains the mode branch. Neither reference establishes how an installed locale displays the results, so do not treat the table as an automated native regression test. KDE examples · Source.

Additional verified-by-arithmetic examples

Enter as a formula Independently expected value Why
=FLOOR(12.5) 12 Default positive unit increment; official example.
=FLOOR(-12.5) -13 Default negative unit increment with omitted mode; official example.
=FLOOR(5;2) 4 Largest multiple of 2 no greater than 5; official example.
=FLOOR(5;2.2) 4.4 Fractional multiple; explicit KDE example.
=FLOOR(6;3) 6 Already an exact multiple.
=FLOOR(17;6) 12 A limit of 17 admits at most two full six-unit packages.
=FLOOR(-6.43;-4;0) -8 Negative-infinity direction with mode 0, based on source branch.
=FLOOR(-6.43;-4;1) -4 Toward-zero direction with nonzero mode, based on source branch.
=FLOOR(0) 0 Explicit zero-number short circuit in source; runtime untested.

For exact multiples or borderline decimal inputs, results are subject to floating-point representation, tolerance comparisons and formatting. Avoid relying on the final displayed decimal digit without native checks in the installed version. KDE handbook · 26.08.2 source.

Advanced use: material cutting and leftover estimation

Suppose a woodworking shop has a stock length of 127 cm in B10 and wants complete 12 cm pieces in C10. In D10 enter:

=FLOOR(B10;C10)

Expected D10 = 120 cm: ten complete segments fit within the available stock. In E10 enter:

=D10/C10

Expected E10 = 10 full segments. In F10 enter:

=B10-D10

Expected F10 = 7 cm remainder. The example assumes no saw kerf, waste, tolerance or other practical restrictions; those must be included in a real production calculation. A separate way to find the integer count for a positive length would be =FLOOR(B10/C10) (expected 10), and keeping both expressions on the worksheet makes it easier to audit the business logic. This practical calculation is independent arithmetic, not observed execution.

How FLOOR differs from CEILING and MROUND

Take a positive requirement of 52 and an increment of 15. Under the pinned mathematical definitions:

Operation Independently expected result Appropriate use
=FLOOR(52;15) 45 Keep to full increments within 52.
=CEILING(52;15) 60 Ensure capacity at least 52.
=MROUND(52;15) 45 Choose the nearest increment.

CEILING and MROUND have separately registered names/implementations, not aliases of FLOOR. These are comparative independent arithmetic checks. math.cpp registrations.

Errors, limits and troubleshooting

Signs disagree. In the examined C++ implementation, a nonzero negative number with positive significance (or vice versa) fails the explicit sign comparison and returns an internal Value::errorVALUE(); do not promise the exact on-screen translated error without a Calligra test. If working with negative values, try matching negative significance, for example =FLOOR(-6.43;-4;0).

Significance is zero. The source behaves differently for some zero cases: a number approximately equal to zero is short-circuited to numeric zero. When a positive number is paired with an explicit zero significance, it reaches the source’s zero-significance check and returns zero. For a negative number paired with zero, the preceding sign check can instead produce an internal value error. This is implementation analysis only, not a promise that every build or locale shows the same value. Avoid zero significance when planning nonzero physical units. Exact ordering of checks.

Confusing direction on negative inputs. With mode 0 or omitted, -6.43 on multiples of -4 yields an expected -8; with nonzero mode, an expected -4. Do not reverse the meanings of FLOOR and CEILING based only on common English descriptions. KDE source.

More than three arguments, invalid types, or cells formatted as text. Registration accepts 1–3 positions, while the XML describes floating-point arguments. Missing/extra argument and text-coercion behavior can be handled by formula evaluation outside func_floor; the exact user-visible errors and mixed-cell conversion rules have not been tested. Start with numeric cell entries, inspect the formula bar and verify punctuation through the local Function dialog. The source calls args[0].asFloat() and args[1].asFloat() after other checks, so do not assume another spreadsheet’s treatment of numeric-looking text applies here.

Rounding seems wrong for 5.0 versus 4.999999. Floating arithmetic and formatting can matter near an exact multiple. The source uses approxEqual around zero and comparisons on numeric floating-point operands. Show sufficient decimals to investigate and avoid copying a displayed rounded result into a later calculation without considering precision.

A version or platform discrepancy. These details were checked for the KDE 26.08.2 source (2026-10-08). Confirm the function exists in your installed Sheets version. KDE officially directs Linux users to distribution packages or Flatpak; its download page currently says Windows support is still in progress. A catalogue entry does not establish execution in an arbitrary installation. Release announcement · Calligra downloads.

Calligra’s FLOOR source registration and algorithm establish the documented syntax and implementation for its 26.08.2 release. They do not certify byte-for-byte parity with Excel, Google Sheets, LibreOffice or historic versions of Calligra; negative-number mode, error labels and coercion are sensitive differences. When importing another spreadsheet, confirm the formula text, argument separators, parameter signs and the actual result in your target installation before depending on it in a financial or production workflow.

For related rounding operations, see ROUND, ROUNDDOWN and ROUNDUP. The official related functions list additionally identifies CEIL and CEILING. KDE function reference.

Official sources and validation disclosure (checked October 13, 2026)

  1. KDE Calligra Sheets functions, FLOOR entry — published syntax/examples and rounding-mode descriptions; the function handbook includes some simplified/inconsistent descriptions, so where needed this guide uses the matching release source.
  2. KDE Calligra 26.08.2 math.xml, lines 877–909 — typed parameters, optionality, examples and related functions. Immutable release commit 72123cc643f6625351139e7df294544255a1056f.
  3. KDE Calligra 26.08.2 math.cpp, lines 137–142 and 441–472 — one-to-three argument registration, numeric sign check, mode branch, zero handling and returned numeric value.
  4. KDE Gear 26.08.2 announcement — release dated October 8, 2026.
  5. Official Calligra download and platform information — platform availability cautions, checked October 13, 2026.

Testing limitation: Documentation and pinned source reviewed; ordinary examples independently calculated. Native Calligra, locale, coercion, boundary precision and error display remain untested.