CEILING.MATH in Excel: Round Up by Multiples and Control Negative Values
Use Excel CEILING.MATH for capacity multiples, negative rounding modes and reproducible integer-step checks.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: CEILING.MATH rounds a number upward to an integer or chosen multiple. Positive values move away from zero; negative values move toward zero by default. Its optional mode can reverse the negative direction.
Availability and version history
- Introduced: Marked as an Excel 2013 addition in the Microsoft function catalogue; an exact first 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.
- Checked: October 14, 2026; official CEILING.MATH reference. Examples are independently calculated expectations, not native Excel test results.
Syntax and the rounding step
=CEILING.MATH(number, [significance], [mode])
With only the number supplied, the result is rounded to an integer. In the examples below, a positive significance specifies the spacing between permitted results, such as 5 for multiples of five. It is not a count of decimal places. The optional mode concerns negative values; Microsoft’s reference examples demonstrate nonzero modes that round those values away from zero.
The official prose has inconsistencies in its significance description and extreme numeric bound. This guide uses the multiple-based behavior demonstrated by its examples and ordinary finite inputs. It does not turn the conflicting wording into an asserted boundary or full error-code specification.
Example 1: compare the default signed direction
Enter 7.2, 7, −7.2, −7 in A2:A5. In B2 enter and fill down:
=CEILING.MATH(A2)
Expected B2:B5: 8, 7, −7, −7. An already integral value remains at that integer. For −7.2, moving upward on the number line reaches −7, which is closer to zero.
The word up describes the numerical direction, not necessarily an increase in magnitude. This is why positive and negative inputs need separate tests.
Example 2: choose a multiple rather than decimal places
=CEILING.MATH(32.4,6)
=CEILING.MATH(-32.4,6)
Expected results: 36 and −30. Both are multiples of six. They are the first permitted values at or above the corresponding input when the mode is omitted.
For the positive case, 32.4/6 = 5.4, so the required count of complete six-unit groups is six. Multiplying six groups by six units yields 36. For the negative case, −30 is above −32.4 on the number line.
Example 3: change the negative rounding policy
=CEILING.MATH(-32.4,6,1)
=CEILING.MATH(-32.4,6,-1)
Expected result for both: −36. The documented nonzero-mode examples establish an away-from-zero policy for negative values. The result differs from the omitted-mode answer of −30.
The mode is not a number of digits. Name a worksheet parameter clearly, such as Negative rounding policy, instead of giving it an ambiguous label like Precision.
Advanced example: plan capacity in package multiples
Suppose a fictional workshop needs 13, 24, 25 labels for three jobs, entered in D2:D4. Labels come in packs of six. In E2 enter and fill down:
=CEILING.MATH(D2,6)
Expected capacity: 18, 24, 30 labels. In F2 use =E2/6; expected pack counts are 3, 4, 5. In G2 use =E2-D2; expected spare labels are 5, 0, 5.
For separately packed jobs, total capacity is =SUM(E2:E4), expected 72. If the jobs can share packs, =CEILING.MATH(SUM(D2:D4),6) is 66, because total demand is 62. The six-unit difference comes from rounding each job before adding versus pooling first.
The formula cannot decide whether pooling is operationally allowed. Choose the grouping rule before calculating quantities.
Advanced example: express an upper threshold at quarter units
For a measured value of 10.6 in H2:
=CEILING.MATH(H2,0.25)
Expected result: 10.75. A quarter unit is the spacing; it does not mean two or twenty-five decimal places. For −10.6, omitted mode gives −10.5, while mode 1 gives −10.75.
This example deliberately stays away from a multiple boundary. For precision-sensitive measurements, test values very near your actual thresholds in the target workbook and retain the raw measurement.
Choosing another rounding function
ROUND chooses decimal-place rounding. ROUNDUP always moves away from zero according to a digit count. CEILING.MATH combines a multiple-based step with a negative-direction option, so those functions are not interchangeable just because one positive example happens to agree.
Keep a positive, nonzero step in the documented workflow here. Validate an editable step cell before using it; an accidental zero or negative value should not silently redefine your operational policy. This guide does not claim an exhaustive coercion or error table for those inputs.
The results are new numbers, unlike merely displaying fewer decimals through formatting. Retain original values whenever later calculations require unrounded measurements.
Verification: Fictional inputs and independently calculated outputs; no native Excel execution. See the editorial testing standards.