CEILING.PRECISE in Collabora Office: Round Toward the Higher Multiple

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: support in every online or mobile deployment is not inferred from desktop documentation.
• Checked: October 14, 2026. Complete function-specific documentation and independent arithmetic controls; no native Collabora test was performed.

=CEILING.PRECISE(number[;significance])

Optional significance defaults to 1. Positive inputs move away from zero; negative inputs move toward zero. There is no mode argument.

The Collabora reference states that CEILING.PRECISE and ISO.CEILING calculate identical results. This is explicit product documentation, rather than an inference from their similar names.

Examples use English names and semicolon separators. “Precise” is part of the function name; it does not promise unlimited decimal precision or remove floating-point limitations.

Enter -14, -12, -10, 10, 12 and 14 in A2:A7:

=CEILING.PRECISE(A2;4)

Expected results are -12, -12, -8, 12, 12 and 16. Every result is at least as large as its input on the number line. Exact multiples stay unchanged.

Using -4 as significance gives the same results. A negative step does not reverse the direction.

=CEILING.PRECISE(6.2)
=CEILING.PRECISE(-6.2)

Expected results are 7 and -6. These are mathematical ceilings to the next integer, rather than rounding every magnitude upward.

For -6.2, an away-from-zero answer would be -7. If that alternative is intended, CEILING.MATH offers an explicit negative mode.

Items are packed in boxes holding four. For requirements 9, 12 and 14, use:

=CEILING.PRECISE(D2;4)
=CEILING.PRECISE(D2;4)/4

Expected capacities are 12, 12 and 16; box counts are 3, 3 and 4. Spare capacity is 3, 0 and 2, totaling five places across the three separate orders.

The total requirement is 35. If items may be pooled into a single order, =CEILING.PRECISE(35;4) gives 36, requiring nine boxes and leaving one spare place. Separate orders require ten boxes. Record whether pooling is allowed before comparing these results.

For -14 and a step of four:

=FLOOR.PRECISE(-14;4)
=CEILING.PRECISE(-14;4)

Expected bounds are -16 and -12. The original -14 lies between them. For an exact multiple such as -12, both bounds equal -12.

FLOOR.PRECISE supplies the lower bound with its own fixed downward direction. This paired check is useful when building a visible grid around signed measurements.

Do not add a third mode argument to CEILING.PRECISE. Do not assume it follows unsuffixed CEILING’s opposite-sign error rule; the dedicated PRECISE section explicitly ignores significance’s sign.

Collabora’s broader ceiling page discusses Excel 2010-era PRECISE compatibility. That does not establish this function’s first Collabora release. Native round-trip mapping, zero-step behavior, coercion and extreme floating-point boundaries remain unverified in this guide.

• Collabora Office 26.04: CEILING.PRECISE.
• Editorial testing standards.

The complete function section was reviewed. Worked results are independently checked expectations; native execution and unlisted edge cases remain unverified.