This shows you the differences between two versions of the page.
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]] |