User Tools

Site Tools


function:CEIL

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
function:CEIL [2015/01/18 03:55]
peternlewis
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
  
-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.1421571332.txt.gz · Last modified: 2015/01/18 03:55 by peternlewis