Differences

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

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