This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
function:CEIL [2023/09/20 00:08] peternlewis |
function:CEIL [2023/09/20 04:39] peternlewis |
||
---|---|---|---|
Line 5: | Line 5: | ||
CEIL(5.5) === CEIL(5.1) === CEIL(6) === 6 | CEIL(5.5) === CEIL(5.1) === CEIL(6) === 6 | ||
CEIL(-5.5) === CEIL(-5.1) === CEIL(-5) === -5 | CEIL(-5.5) === CEIL(-5.1) === CEIL(-5) === -5 | ||
+ | |||
+ | The CEIL() function (v11.0+) takes a second optional parameter to indicate the number of decimal digits to operate to: | ||
+ | |||
+ | CEIL(5.6789,2) === 5.68 | ||
+ | CEIL(-5.6789,2) === -5.67 | ||
===== See Also ===== | ===== See Also ===== |