User Tools

Site Tools


function:FLOOR

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:FLOOR [2015/01/18 03:59]
peternlewis
function:FLOOR [2023/09/20 04:41] (current)
peternlewis
Line 1: Line 1:
-The FLOOR() function takes a number and returns the first integer that is less than or equal to the argument:+====== FLOOR Function ====== 
 + 
 +The FLOOR(x) function takes a number and returns the first integer that is less than or equal to the argument:
  
     FLOOR(5.5) === FLOOR(5.1) === FLOOR(5) === 5     FLOOR(5.5) === FLOOR(5.1) === FLOOR(5) === 5
     FLOOR(-5.5) === FLOOR(-5.1) === FLOOR(-6) === -6     FLOOR(-5.5) === FLOOR(-5.1) === FLOOR(-6) === -6
  
-See also [[CEIL]][[TRUNC]], and [[ROUND]].+The FLOOR() function (v11.0+) takes a second optional parameter to indicate the number of decimal digits to operate to: 
 + 
 +    FLOOR(5.6789,​2) === 5.67 
 +    FLOOR(-5.6789,​2) === -5.68 
 + 
 +===== See Also ===== 
 + 
 +=== Functions === 
 + 
 +[[CEIL]] 
 +[[TRUNC]] 
 +[[ROUND]] 
 +* [[:​Functions|See all Functions]] 
function/FLOOR.1421571573.txt.gz · Last modified: 2015/01/18 03:59 by peternlewis