Differences

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

--- function:ROUND [2015/01/18 09:03] – created peternlewis
+++ function:ROUND [2023/09/20 08:42] (current) – peternlewis
@@ Line 1: / Line 1: @@
+====== ROUND Function ======
 The ROUND() function takes a number and returns the nearest integer to the argument.  Numbers that are exactly half way (ie, end in ".5") round away from zero.
@@ Line 4: / Line 6: @@
     ROUND(-5.5) === ROUND(-5.9) === ROUND(-6.3) === -6
-See also [[CEIL]], [[FLOOR]], and [[TRUNC]].
+The ROUND() function (v11.0+) takes a second optional parameter to indicate the number of decimal digits to round to:
+    ROUND(5.6789,2) === 5.68
+    ROUND(-5.6789,2) === -5.68
+===== See Also =====
+=== Functions ===
+* [[CEIL]]
+* [[FLOOR]]
+* [[TRUNC]]
+* [[:Functions|See all Functions]]