CEILING.PRECISE in Excel: Apply a Mathematical Upper Multiple

• Introduced: Added in Excel 2010, according to Microsoft’s new-function history; the first numeric build is not established.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel Web App.
• Checked: October 14, 2026; official CEILING.PRECISE reference. Examples are independently calculated expectations, not native Excel test results.

=CEILING.PRECISE(number, [significance])

The number is required. Significance is optional and defaults to one. For a nonzero step, the result is the smallest permitted multiple at or above the input. Microsoft documents that a zero number or zero significance returns zero. Official CEILING.PRECISE reference

PRECISE identifies this function’s consistent mathematical direction. It does not promise unlimited numerical precision, eliminate floating-point effects or guarantee a particular number of decimal places. There is no separate negative-direction mode argument.

=CEILING.PRECISE(13.4)
=CEILING.PRECISE(-13.4)
=CEILING.PRECISE(13)

Expected results: 14, −13, 13. The positive fraction moves to the next integer away from zero. The negative fraction moves upward toward zero. The integer is already a permitted result.

Draw a number line if the negative result feels surprising: −13 is greater than −13.4. Up refers to numerical order rather than absolute magnitude.

=CEILING.PRECISE(13.4,4)
=CEILING.PRECISE(13.4,-4)
=CEILING.PRECISE(-13.4,4)
=CEILING.PRECISE(-13.4,-4)

Expected results: 16, 16, −12, −12. The two signs of the step describe the same spacing because the function uses its absolute value.

For −13.4, the neighboring four-unit multiples are −16 and −12. The upper one is −12. Supplying −4 cannot make this function select −16 instead.

=CEILING.PRECISE(13.4)
=CEILING.PRECISE(13.4,0)
=CEILING.PRECISE(0,4)

Expected results: 14, 0, 0. An omitted step selects the documented default of one; an explicit zero is a separate documented case.

If a worksheet step parameter is accidentally zero, its result may look like a valid numerical answer rather than an obvious error. Validate that parameter when zero does not make sense for the task.

A fictional store has item counts 17, 24, 25 in A2:A4. Each container holds eight items. In B2 enter and fill down:

=CEILING.PRECISE(A2,8)

Expected capacity figures: 24, 24, 32. In C2 use =B2/8; expected container counts are 3, 3, 4. In D2 use =B2-A2; unused capacity is 7, 0, 7.

Total demand is 66, while separately assigned capacity is 80. If all items may share containers, =CEILING.PRECISE(SUM(A2:A4),8) gives 72, or nine containers. Separate assignment needs ten containers. The formula exposes the difference but does not decide whether combining stock is acceptable.

Ordinary multiples start from zero. To round upward onto a grid starting at 2 with spacing 5, subtract the origin, round, then add it back:

=2+CEILING.PRECISE(A2-2,5)

For A2 values 3, 7, 8, −1, expected results are 7, 7, 12, 2. Those all belong to the sequence …, −3, 2, 7, 12, … .

For input −1, the translated value is −3; its upper five-unit multiple is zero, then adding the origin returns 2. This example shows why rounding the original value first and adding two afterward would implement a different grid.

=CEILING.PRECISE(10.6,0.25)
=CEILING.PRECISE(-10.6,0.25)

Expected results: 10.75 and −10.5. A quarter is the allowed increment, not a digit count. Keep the raw measurement in another cell if downstream calculations should use its original value.

When verifying a nonzero-step result, check both that it is on the grid and that it is no smaller than the input. With ordinary exact inputs, the distance to the result is less than one step unless the input already lies on the grid, when the distance is zero.

ROUNDUP uses decimal digits and moves negative values away from zero. It therefore answers a different question. If the negative direction needs to vary, select a function with a documented mode rather than changing the sign of CEILING.PRECISE’s significance.

This guide checks ordinary numeric inputs and documented zero cases. It does not claim a complete text-coercion, extreme-value or error-code table. Test boundary values in the intended workbook, especially after importing measurements or converting units.

Verification: Fictional inputs and independently calculated outputs; no native Excel execution. See the editorial testing standards.