CEILING
The CEILING function rounds a number to the nearest integer or to the nearest multiple of significance.
Syntax
Arguments
value - Number or reference. This is a required argument.
significance - Multiple to which the number should be rounded. This is an optional argument. If missing, the number is rounded to the nearest integer greater than the number.
Example
Returns 15 which is the smallest multiple of 5 larger than 13
Excel equivalent
Last updated