Differences

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

--- function:FLOOR [2015/01/18 08:59] – peternlewis
+++ function:FLOOR [2023/09/20 08: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(-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]]