What is the syntax for CEILING.MATH in Excel?

The syntax for CEILING.MATH is: =CEILING.MATH(number, [significance], [mode])

How do I use the CEILING.MATH function?

To use CEILING.MATH, type =CEILING.MATH( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What happens if CEILING.MATH encounters errors?

If CEILING.MATH encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.

Why is CEILING.MATH not working in my Excel?

Common issues with CEILING.MATH include Returns 0 if significance is 0. Start by checking the syntax =CEILING.MATH(number, [significance], [mode]), then verify each referenced cell or range.

Math & Trig

CEILING.MATH Function in Excel

Rounds a number up to the nearest integer or to the nearest multiple of significance.

Syntax

=CEILING.MATH(number, [significance], [mode])

Arguments

number (required): Number to round up
significance (optional): Multiple to round to
mode (optional): Direction for negative numbers

Examples

=CEILING.MATH(6.3) - Round up to integer - Result: 7
=CEILING.MATH(-6.7, 2, 1) - Round negative toward zero - Result: -6

CEILING.MATH in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

Returns 0 if significance is 0

Use cases

Rounding up
Pricing
Time intervals

Frequently asked questions

What is the CEILING.MATH function in Excel? CEILING.MATH rounds a number up to the nearest integer or to the nearest multiple of significance. The syntax is =CEILING.MATH(number, [significance], [mode]). Typical use cases include rounding up, pricing, time intervals.
How do I use the CEILING.MATH function? To use CEILING.MATH, type =CEILING.MATH( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What happens if CEILING.MATH encounters errors? If CEILING.MATH encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.
Why is CEILING.MATH not working in my Excel? Common issues with CEILING.MATH include Returns 0 if significance is 0. Start by checking the syntax =CEILING.MATH(number, [significance], [mode]), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.