Rounds a number up to the nearest integer multiple of specified significance factor.
Sample Usage
CEILING(5.25, 0.1)
CEILING(C5,1)
Syntax
CEILING(number, [factor])
- number - The number to be rounded.
- factor - [OPTIONAL] The number to whose multiples the value will be rounded.
Examples
CEILING(5.25, 0.1) returns a value of 5.3.
CEILING(A4, A5) rounds the number in A4 to the nearest integer multiple of number in A5.
Notes
- If number is positive, then factor must also be positive.
- If number is an exact multiple of factor, no rounding occurs.
- If number is negative and factor is positive, then number is rounded up towards zero.
- If number is negative and factor is negative, then number is rounded down, away from zero.