Manuals/calci/ROUNDUP - Revision history

Devika at 21:35, 21 August 2018

2018-08-21T21:35:56Z

2018-07-03T20:28:31Z

2017-03-13T11:19:21Z

2015-04-29T14:23:58Z

2013-11-27T22:53:54Z

2013-11-27T22:43:08Z

2013-11-27T22:35:35Z

Examples

2013-11-27T22:25:00Z

2013-11-27T22:22:52Z

2013-11-27T22:11:36Z

@@ Line 1: / Line 1: @@
-=ROUNDUP(number, num_of_digits)=
+<div style="font-size:30px">'''ROUNDUP (number,num_digits)'''</div><br/>
 *Where 'number' is the number to round and
 *'num_of_digits' is the number of digits to which the number is to be rounded.
+**ROUNDUP(), rounds a number up, away from zero.
 == Description ==

@@ Line 4: / Line 4: @@
 *'num_of_digits' is the number of digits to which the number is to be rounded.
-ROUNDUP() rounds a number to specified number of digits away from 0.
+ROUNDUP(), rounds a number up, away from zero.
 == Description ==

← Older revision		Revision as of 11:19, 13 March 2017
Line 103:		Line 103:

	*[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 79: / Line 79: @@
 | class="sshl_f" | -10
 |}
 == See Also ==

@@ Line 26: / Line 26: @@
 ROUNDUP() can also be used for multiple number array as -
-ROUNDUP(2.55..7.55,1) that rounds the numbers 2.55 to 6.55 to one decimal place.
+ROUNDUP(2.55..7.55,1) that rounds the numbers 2.55 to 7.55 to one decimal place.
 {| class="wikitable"

@@ Line 10: / Line 10: @@
 ROUNDUP(number, num_of_digits)
-This function is used to round a number up  away from zero, to specified number of decimal digits mentioned in the argument.
+This function is used to round a number up  away from zero, to the number of decimal digits specified in the argument.
 For Example,

@@ Line 60: / Line 60: @@
 |- class="odd"
-| class="sshl_f" | ROUND(3.6712,2)
+| class="sshl_f" | ROUNDUP(7.6712,2)
-| class="sshl_f" | 3.67
+| class="sshl_f" | 7.68
 |- class="even"
-| class="sshl_f" | ROUND(99.37,0)
+| class="sshl_f" | ROUNDUP(388.345,0)
-| class="sshl_f" | 99
+| class="sshl_f" | 389
 |- class="odd"
-| class="sshl_f" | ROUND(99.37)
+| class="sshl_f" | ROUNDUP(199.37,-1)
-| class="sshl_f" | 99
+| class="sshl_f" | 200
 |- class="even"
-| class="sshl_f" | ROUND(145.8,-1)
+| class="sshl_f" | ROUNDUP(-9.95,1)
-| class="sshl_f" | 150
+| class="sshl_f" | -10
 |- class="odd"
-| class="sshl_f" | ROUND(-89.65,1)
+| class="sshl_f" | ROUNDUP(-9.95,-1)
-| class="sshl_f" | -89.7
+| class="sshl_f" | -10
 |}

← Older revision		Revision as of 22:25, 27 November 2013
Line 49:		Line 49:
	*ROUNDDOWN() can be used to round a number towards zero.		*ROUNDDOWN() can be used to round a number towards zero.
	*MROUND() can be used to round a number to desired multiple.		*MROUND() can be used to round a number to desired multiple.
		+
		+	== Examples ==
		+
		+	<div id="6SpaceContent" class="zcontent" align="left">
		+
		+	{\| id="TABLE3" class="SpreadSheet blue"
		+	\|- class="even"
		+	\| class=" " \| '''Function'''
		+	\| class=" " \| '''Output'''
		+
		+	\|- class="odd"
		+	\| class="sshl_f" \| ROUND(3.6712,2)
		+	\| class="sshl_f" \| 3.67
		+
		+	\|- class="even"
		+	\| class="sshl_f" \| ROUND(99.37,0)
		+	\| class="sshl_f" \| 99
		+
		+	\|- class="odd"
		+	\| class="sshl_f" \| ROUND(99.37)
		+	\| class="sshl_f" \| 99
		+
		+	\|- class="even"
		+	\| class="sshl_f" \| ROUND(145.8,-1)
		+	\| class="sshl_f" \| 150
		+
		+	\|- class="odd"
		+	\| class="sshl_f" \| ROUND(-89.65,1)
		+	\| class="sshl_f" \| -89.7
		+
		+	\|- class="odd"
		+	\| class="sshl_f" \| ROUND(-89.65,-1)
		+	\| class="sshl_f" \| -90
		+	\|}
		+
		+	== See Also ==
		+
		+	*[[Manuals/calci/ROUNDDOWN \| ROUNDDOWN]]
		+
		+	*[[Manuals/calci/ROUND \| ROUND]]
		+
		+	*[[Manuals/calci/MROUND \| MROUND]]
		+
		+	*[[Manuals/calci/INT \| INT]]
		+
		+	*[[Manuals/calci/TRUNC \| TRUNC]]
		+
		+	*[[Manuals/calci/CEILING \| CEILING]]
		+
		+	*[[Manuals/calci/FLOOR \| FLOOR]]
		+
		+	==References==
		+
		+	*[http://en.wikipedia.org/wiki/Rounding Round Function]

@@ Line 26: / Line 26: @@
 ROUNDUP() can also be used for multiple number array as -
-ROUNDUP(2.55..7.55,1) that rounds the numbers from 2.5 to 6 in steps of 0.5.
+ROUNDUP(2.55..7.55,1) that rounds the numbers 2.55 to 6.55 to one decimal place.
 {| class="wikitable"
 |-
-! Number !! ROUNDUP
+! Number !! Num_of_digits !! ROUNDUP
 |-
-| 2.5 || 3
+| 2.55 || 1 || 2.6
 |-
-| 3 || 3
+| 3.55 || 1 || 3.6
 |-
-| 3.5 || 4
+| 4.55 || 1 || 4.6
 |-
-| 4 || 4
+| 5.55 || 1 || 5.6
 |-
-| 4.5 || 5
+| 6.55 || 1 || 6.6
 |-
-| 5 || 5
+| 7.55 || 1 || 7.6
 |-
 |}

@@ Line 14: / Line 14: @@
 For Example,
-ROUNDUP((67.8,0) ''returns 68'' as a result.
+ROUNDUP(67.8,0) ''returns 68'' as a result.
-ROUNDUP((6.83112,3) ''returns 6.832'' as a result.
+ROUNDUP(6.83112,3) ''returns 6.832'' as a result.
-*If 'num_of_digits' is omitted, Calci assumes it to be zero and rounds the number to the nearest integer.
+*If 'num_of_digits' is omitted, Calci displays #NaN error message.
-*The number is rounded to the specified number of decimal places, if num_of_digits > 0.
+*The number is rounded up to the specified number of decimal places, if num_of_digits > 0.
-*The number is rounded to the nearest integer, if num_of_digits = 0.
+*The number is rounded up to the nearest integer, if num_of_digits = 0.
-*The number is rounded to the left of the decimal point, if num_of_digits < 0.
+*The number is rounded up to the left of the decimal point, if num_of_digits < 0.
 *If any argument is non-numeric, Calci displays #NaN error message.
 ROUNDUP() can also be used for multiple number array as -
-ROUNDUP(2.5..6..0.5) that rounds the numbers from 2.5 to 6 in steps of 0.5.
+ROUNDUP(2.55..7.55,1) that rounds the numbers from 2.5 to 6 in steps of 0.5.
 {| class="wikitable"
@@ Line 53: / Line 53: @@
 *ROUNDDOWN() can be used to round a number towards zero.
 *MROUND() can be used to round a number to desired multiple.