Manuals/calci/ROUND - Revision history

Devika at 21:33, 21 August 2018

2018-08-21T21:33:30Z

2018-07-03T20:21:17Z

2018-07-03T20:20:34Z

2017-03-13T11:18:54Z

2015-04-29T14:23:24Z

2013-12-03T22:07:06Z

Examples

2013-11-27T22:36:42Z

2013-11-27T19:01:56Z

2013-11-27T18:58:12Z

2013-11-27T18:53:16Z

@@ Line 3: / Line 3: @@
 *Where 'Number' is the number to round and
 *'Decimals' is the number of digits to which the number is to be rounded.
 **ROUND() rounds a number to specified number of digits.

@@ Line 4: / Line 4: @@
 *'Decimals' is the number of digits to which the number is to be rounded.
-ROUND() rounds a number to specified number of digits.
+**ROUND() rounds a number to specified number of digits.
 == Description ==

@@ Line 1: / Line 1: @@
-=ROUND(number, num_of_digits)=
+<div style="font-size:30px">'''ROUND(Number,Decimals)'''</div><br/>
-*Where 'number' is the number to round and
+*Where 'Number' is the number to round and
-*'num_of_digits' is the number of digits to which the number is to be rounded.
+*'Decimals' is the number of digits to which the number is to be rounded.
 ROUND() rounds a number to specified number of digits.
@@ Line 8: / Line 8: @@
 == Description ==
-ROUND(number, num_of_digits)
+ROUND(Number,Decimals)
 This function is used to round a number to certain number of digits mentioned in the argument.
@@ Line 18: / Line 18: @@
 ROUND(411.3,-1) ''returns 410'' as a result.
-*If 'num_of_digits' is omitted, Calci assumes it to be zero and rounds the number to the nearest integer.
+*If 'Decimals' is omitted, Calci assumes it to be zero and rounds the number to the nearest integer.
-*The number is rounded to the specified number of decimal places, if num_of_digits > 0.
+*The number is rounded to the specified number of decimal places, if Decimals > 0.
-*The number is rounded to the nearest integer, if num_of_digits = 0.
+*The number is rounded to the nearest integer, if Decimals = 0.
-*The number is rounded to the left of the decimal point, if num_of_digits < 0.
+*The number is rounded to the left of the decimal point, if Decimals < 0.
 *If any argument is non-numeric, Calci displays #NaN error message.

← Older revision		Revision as of 11:18, 13 March 2017
Line 111:		Line 111:

	*[http://en.wikipedia.org/wiki/Rounding Round Function]		*[http://en.wikipedia.org/wiki/Rounding Round Function]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 87: / Line 87: @@
 | class="sshl_f" | -90
 |}
 == See Also ==

@@ Line 83: / Line 83: @@
 | class="sshl_f" | -89.7
-|- class="odd"
+|- class="even"
 | class="sshl_f" | ROUND(-89.65,-1)
 | class="sshl_f" | -90

@@ Line 26: / Line 26: @@
 ROUND() can also be used for multiple number array as -
-ROUND(2.5..6..0.5) that rounds the numbers from 2.5 to 6 in steps of 0.5.
+ROUND(2.5..6..0.5) that rounds the numbers 2.5 to 6 in steps of 0.5.
 {| class="wikitable"

← Older revision		Revision as of 19:01, 27 November 2013
Line 2:		Line 2:

	*Where 'number' is the number to round and		*Where 'number' is the number to round and
−	*'num_of_digits' is the number of digits ~~before or after decimal point~~.	+	*'num_of_digits' is the number of digits to which the number is to be rounded.

	ROUND() rounds a number to specified number of digits.		ROUND() rounds a number to specified number of digits.
Line 62:		Line 62:
	\| class=" " \| '''Function'''		\| class=" " \| '''Function'''
	\| class=" " \| '''Output'''		\| class=" " \| '''Output'''
−	\|	+
	\|- class="odd"		\|- class="odd"
	\| class="sshl_f" \| ROUND(3.6712,2)		\| class="sshl_f" \| ROUND(3.6712,2)
	\| class="sshl_f" \| 3.67		\| class="sshl_f" \| 3.67
−	\|	+
	\|- class="even"		\|- class="even"
	\| class="sshl_f" \| ROUND(99.37,0)		\| class="sshl_f" \| ROUND(99.37,0)
	\| class="sshl_f" \| 99		\| class="sshl_f" \| 99
−	\|	+
	\|- class="odd"		\|- class="odd"
	\| class="sshl_f" \| ROUND(99.37)		\| class="sshl_f" \| ROUND(99.37)
	\| class="sshl_f" \| 99		\| class="sshl_f" \| 99
−	\|	+
	\|- class="even"		\|- class="even"
	\| class="sshl_f" \| ROUND(145.8,-1)		\| class="sshl_f" \| ROUND(145.8,-1)
	\| class="sshl_f" \| 150		\| class="sshl_f" \| 150
−	\|	+
	\|- class="odd"		\|- class="odd"
	\| class="sshl_f" \| ROUND(-89.65,1)		\| class="sshl_f" \| ROUND(-89.65,1)
	\| class="sshl_f" \| -89.7		\| class="sshl_f" \| -89.7
−	\|	+
		+	\|- class="odd"
		+	\| class="sshl_f" \| ROUND(-89.65,-1)
		+	\| class="sshl_f" \| -90
	\|}		\|}

@@ Line 49: / Line 49: @@
 |-
 |}
 == Examples ==
@@ Line 99: / Line 103: @@
 ==References==
-*[http://en.wikipedia.org/wiki/Truncation TRUNC Function]
+*[http://en.wikipedia.org/wiki/Rounding Round Function]

@@ Line 30: / Line 30: @@
 {| class="wikitable"
 |-
-! Number !! ROUND Output
+! Number !! ROUND
 |-
 | 2.5 || 3
@@ Line 60: / Line 60: @@
+|
 |- class="odd"
-| class="sshl_f" | 3.6712
+| class="sshl_f" | ROUND(3.6712,2)
-| class="sshl_f" | 2
+| class="sshl_f" | 3.67
+|
 |- class="even"
-| class="sshl_f" | 3.67
+| class="sshl_f" | ROUND(99.37,0)
-| class="sshl_f" |
+| class="sshl_f" | 99
+|
 |- class="odd"
-| class="sshl_f" |
+| class="sshl_f" | ROUND(99.37)
-| class="sshl_f" |
+| class="sshl_f" | 99
+|
 |- class="even"
-| class="sshl_f" |
+| class="sshl_f" | ROUND(145.8,-1)
-| class="sshl_f" |
+| class="sshl_f" | 150
+|
 |- class="odd"
-| class="sshl_f" |
+| class="sshl_f" | ROUND(-89.65,1)
-| class="sshl_f" |
+| class="sshl_f" | -89.7
+|
 |}