Related Functions:

The CEILING.PRECISE function returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.

• This function was introduced in Excel 2010 and so is not available in earlier versions.

### Syntax

=CEILING.PRECISE(number,[significance])

#### Arguments

Argument Description
number The value to be rounded
[significance] Optional. The multiple to which number is to be rounded

 • If omitted, the [significance] argument takes on the default value 1, i.e. round up to the nearest integer • If the [significance] argument is zero, the function returns the value 0 • The arithmetic sign of the [significance] argument is ignored, i.e. the function gives the same result for both positive and negative [significance] values

Note: The absolute value of the multiple is used, so that the CEILING.PRECISE function returns the mathematical ceiling irrespective of the signs of number and significance; i.e.:

• Positive values are rounded away from zero, becoming more positive
• Negative numbers are rounded towards zero, becoming less negative

#### Examples

A B C
1 Formula Result Notes
2 =CEILING.PRECISE(4.3) 5 Rounds 4.3 up to the nearest multiple of 1
3 =CEILING.PRECISE(-4.3) -4 Rounds -4.3 up to the nearest multiple of 1. Rounds toward 0 because the number is negative
4 =CEILING.PRECISE(4.3,2) 6 Rounds 4.3 up to the nearest multiple of 2
5 =CEILING.PRECISE(4.3,-2) 6 Rounds 4.3 up to the nearest multiple of -2

#### Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if one or both of the supplied arguments are non-numeric