CEILING
Syntax:
CEILING ( x , significance )
Description: Computes a value that is x rounded-up, away from zero, to the nearest multiple of significance. Regardless of the sign of x, a value is rounded up when adjusted away from zero.
Arguments:
Name |
Type |
Description |
---|---|---|
x |
number |
The value to be rounded |
significance |
number |
The multiple to which x is to be rounded. |
Return Type and Value: number – The rounded-up value of x.
However, if x and significance have different signs, #NUM!
is returned.
example: