Rounds the number up to the nearest multiple of the specified significance.

Syntax

ceiling( number, significance )

number: (Decimal) A number, the ceiling of which will be returned.

significance: (Decimal) The number will be rounded to the lowest multiple of the significance that is greater than the number.

Returns

Number

Examples

ceiling(7.32,.5) returns 7.5