Excel CEILING.PRECISE Function

Related Functions:
CEILING
FLOOR.PRECISE
Excel Rounding Functions

The Excel Ceiling.Precise function is one of fifteen rounding functions in Excel.

A full list, along with comparison tables, is provided on the Excel Rounding Functions page.

Basic Description

The Excel Ceiling.Precise function rounds a supplied number up (regardless of the number's sign), to the nearest multiple of a given number.

I.e. Positive values are rounded away from zero (becoming more positive) and negative numbers are rounded towards zero (becoming less negative).

The syntax of the Ceiling.Precise function is:

CEILING.PRECISE( number, [significance] )

Where the arguments are as follows:

number-The initial number that is to be rounded up
[significance]-

An optional argument that specifies the multiple of significance to round the supplied number up to.

If omitted, the [significance] argument takes on the default value 1 (i.e. round up to the nearest integer).

Note that the arithmetic sign of the [significance] argument is ignored. The supplied number is rounded up for both positive and negative [significance] values.


Ceiling.Precise Function Examples

In the following spreadsheet, the Excel Ceiling.Precise function is used to round up the positive and negative numbers 22.25 and -22.25, to several different significance values.

 Formulas:
 AB
1numberceiling.precise
222.25=CEILING.PRECISE( A2, 0.1 )
322.25=CEILING.PRECISE( A3, 0.5 )
422.25=CEILING.PRECISE( A4, 1 )
522.25=CEILING.PRECISE( A5 )
622.25=CEILING.PRECISE( A6, 10 )
722.25=CEILING.PRECISE( A7, 0 )
8-22.25=CEILING.PRECISE( A8, 1 )
9-22.25=CEILING.PRECISE( A9, -1 )
10-22.25=CEILING.PRECISE( A10, 5 )
 Results:
 AB
1numberceiling.precise
222.2522.3
322.2522.5
422.2523
522.2523
622.2530
7-22.250
8-22.25-22
9-22.25-22
10-22.25-20

The above examples show how:


Further information and examples of the Excel Ceiling.Precise function can be found on the Microsoft Office website.


Ceiling.Precise Function Error

If you get an error from the Excel Ceiling.Precise function, this is likely to be the #VALUE! error:

Common Error
#VALUE!-Occurs if one or both of the supplied arguments are non-numeric.