What is the syntax for CEILING.PRECISE in Excel?

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

How do I use the CEILING.PRECISE function?

To use CEILING.PRECISE, type =CEILING.PRECISE( 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.PRECISE encounters errors?

If CEILING.PRECISE 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.PRECISE not working in my Excel?

Common issues with CEILING.PRECISE include Always rounds away from zero. Start by checking the syntax =CEILING.PRECISE(number, [significance]), then verify each referenced cell or range.

Math & Trig

CEILING.PRECISE Function in Excel

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

Syntax

=CEILING.PRECISE(number, [significance])

Arguments

number (required): Number to round up
significance (optional): Multiple to round to

Examples

=CEILING.PRECISE(4.3) - Round up to integer - Result: 5
=CEILING.PRECISE(-4.3) - Round negative up - Result: -4

CEILING.PRECISE 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

Always rounds away from zero

Use cases

Consistent rounding
Financial calculations
Data processing

Frequently asked questions

What is the CEILING.PRECISE function in Excel? CEILING.PRECISE rounds a number up to the nearest integer or to the nearest multiple of significance, regardless of sign. The syntax is =CEILING.PRECISE(number, [significance]). Typical use cases include consistent rounding, financial calculations, data processing.
How do I use the CEILING.PRECISE function? To use CEILING.PRECISE, type =CEILING.PRECISE( 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.PRECISE encounters errors? If CEILING.PRECISE 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.PRECISE not working in my Excel? Common issues with CEILING.PRECISE include Always rounds away from zero. Start by checking the syntax =CEILING.PRECISE(number, [significance]), then verify each referenced cell or range.

Editorial review

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