Differences

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

--- syntax:functions:round [2021/07/31 21:49] – craigt
+++ syntax:functions:round [2023/02/28 20:13] (current) – [See also] fix MRound page reference -CT craigt
@@ Line 5: / Line 5: @@
 =====Description=====
 This function rounds a number to //dec_places// number of decimal digits.
+\\
+=====Alternative syntax=====
+The 2nd argument in this function is optional. If omitted, it's assumed to be 0.
+  Round(number)  //The same as Round(number, 0)
 \\
@@ Line 10: / Line 16: @@
 ^Argument^Type^Description^
 |number|Number|The value, usually fractional, to be rounded.|
-|dec_places|Number (positive, >=0)|The number of decimal places to round //number// to.|
+|dec_places|Number (from -9 to 28)|The number of decimal places to round //number// to.|
 \\
 **Return value type:**  Number
@@ Line 23: / Line 29: @@
 =====Examples=====
-  round(5.55, 1) = 5.6
+  round(5.55, 1) //Returns 5.6
-  round(5.65, 1) = 5.6
-  round(101.567, 2) = 101.57
+  round(5.65, 1) //Returns 5.6
-  round(101.5784, 3) = 101.578
-  round(92.523, 0) = 93
+  round(101.567, 2) //Returns 101.57
+  round(101.5784, 3) //Returns 101.578
+  round(92.523, 0) //Returns 93
+  round(12345, -2) //Returns 12300
 \\
 ===== See also =====
   * [[syntax:functions:ceiling|Ceiling(number)]]
   * [[syntax:functions:floor|Floor(number)]]
+  * [[syntax:functions:mround|MRound(number, grain)]]
   * [[syntax:functions:roundxl|RoundXL(number, dec_places)]]
   * [[syntax:functions:truncate|Truncate(number)]]