User Tools

Site Tools


function:CEIL

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
function:CEIL [2015/01/18 03:54]
peternlewis created
function:CEIL [2023/09/20 04:39] (current)
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
 +
 +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.1421571277.txt.gz · Last modified: 2015/01/18 03:54 by peternlewis