Compatibility - CEILING Function
Description
The CEILING function returns a number rounded up, away from zero, to the nearest multiple of significance.
Syntax
CEILING (number, significance)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Number | The value you want to round. | Required |
Significance | The multiple to which Number is to be rounded. | Required |
Notes
Regardless of the sign of number, a value is rounded up when adjusted away from zero. If the number is an exact multiple of significance, no rounding occurs.
If the number is negative, and significance is negative, the value is rounded down, away from zero.
If the number is negative, and significance is positive, the value is rounded up towards zero.
If either argument is nonnumeric, CEILING returns the #VALUE! error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016.