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