CEILING

The CEILING function rounds a number to the nearest integer or to the nearest multiple of significance.

Syntax

ceiling(value, significance)

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

CEILING