User Tools
function:CEIL
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
function:CEIL [2015/01/18 03:55] peternlewis |
function:CEIL [2023/09/20 04:39] peternlewis |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | The CEIL() function takes a number and returns the first integer that is greater than or equal to the argument: | + | ====== CEIL Function ====== |
| + | |||
| + | The CEIL(x) function takes a number and returns the first integer that is greater than or equal to the argument: | ||
| 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 | ||
| - | See also [[FLOOR]]. | + | 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 ===== | ||
| + | |||
| + | === Functions === | ||
| + | |||
| + | * [[FLOOR]] | ||
| + | * [[TRUNC]] | ||
| + | * [[ROUND]] | ||
| + | * [[:Functions|See all Functions]] | ||
function/CEIL.txt · Last modified: 2023/09/20 04:39 by peternlewis
Page Tools
