[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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 |
|
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:
CEILING(2.5,1) rounds 2.5 up to nearest multiple of 1; that is, to 3
CEILING(-2.5,-2) rounds -2.5 up to nearest multiple of -2; that is, to -4
CEILING(1.5,0.1) rounds 1.5 up to the nearest multiple of 0.1; that is, to 1.5
CEILING(0.234,0.01) rounds 0.234 up to the nearest multiple of 0.01; that is, to 0.24
end example]