CEILING.PRECISE

What it does

CEILING.PRECISE(number, [significance])

CEILING.PRECISE(number,[significance]) rounds to a multiple of the absolute step, toward positive infinity in the mathematical convention. The default step is one. The significance sign is ignored and this spelling has no mode argument. Its current quotient-reading approximation is described below.

Try it

=CEILING.PRECISE(-10.3,-3) returns -9. Changing the significance to positive three gives the same value: the step magnitude controls the grid, while the function chooses the direction.

=CEILING.PRECISE(31.2,3) returns 33. These ordinary examples separate the direction from the significance sign.

Quirks

The absolute significance is used, including for negative numbers. A zero number or zero significance returns zero. The current wrapper uses a default of one when significance is omitted at the end of the call; an explicitly empty significance slot is read as zero.

The PRECISE spelling does not establish a correctly rounded mathematical result on every input. The current helper applies a fifteen-digit reading to the quotient before choosing the integer count. The legacy FLOOR measurements do not establish all transferred modern-family boundaries; preserve that limitation.

How to implement

1. Read the number and apply the omitted significance default of one. Set s=abs(significance) and return positive zero for s equal to zero.
2. Compute the current fifteen-significant-digit quotient reading using ordinary binary64 division, nearest/even decimal quantization and conversion back to binary64.
3. Take the ceiling of the signed quotient number/s. The current helper expresses the negative branch using a positive magnitude quotient and the opposite integer direction, then restores the sign.
4. Multiply the selected count by s with the ported helper’s ordinary binary64 multiplication, normalize zero and apply worksheet number publication.

For number=-10.3,s=3, the magnitude quotient is near 3.43333333333333. Choosing three steps gives -9. Do not infer the significance sign from the input’s sign; this spelling discards it.

This branch outline follows the current scalar helper, with the quotient-reading primitive linked above. The exact modern-spelling edge transfer remains open in FN-FLOOR-002; a shared helper does not prove that Excel privately uses the same program for every spelling.

Rust code

2 ceiling_precise "CEILING.PRECISE" (1, 2) [V "number", V "significance"] |s, a, sv| {
    two(s, a, cf::ceiling_precise_kernel)
}

pub fn ceiling_precise_kernel(number: f64, significance: f64) -> Result<f64, WorksheetErrorCode> {
    ceiling_math_kernel(number, significance, 0.0)
}

No implementation has been published with a Handbook test suite for this function.

Version differences

The recorded environments below distinguish a reading from a same-input comparison. Counts describe captured inputs in each environment; overlapping captures and comparisons are not totals of unique worksheet calls.

The record contains no same-input comparison between these environments. Reading different inputs on different builds does not establish either a version change or cross-build agreement.

Recorded environments and comparison details.

Alternatives

MROUND chooses a nearest multiple; ROUNDUP and ROUNDDOWN address decimal positions. FLOOR.MATH provides the other directional family.

Named variants

No named variants are recorded yet.