Manuals/calci/TRUNC - Revision history

Devika at 21:52, 21 August 2018

2018-08-21T21:52:29Z

2018-07-09T18:27:19Z

2017-03-13T11:23:40Z

2017-01-27T20:04:50Z

Description

2015-07-02T18:59:14Z

2013-11-24T22:12:37Z

2013-11-24T22:11:55Z

2013-11-24T22:10:47Z

References

2013-11-24T22:08:08Z

Description

2013-11-24T22:04:38Z

@@ Line 2: / Line 2: @@
 *Where 'Number' is the number to truncate and
 *'Number_Digits' is a number specifying the number of decimal places to be displayed in the result.
+**TRUNC(), truncates a number to an integer.

@@ Line 1: / Line 1: @@
-=TRUNC(number, digits)=
+<div style="font-size:30px">'''TRUNC (Number,Number_Digits)'''</div><br/>
-*Where 'number' is the number to truncate and
+TRUNC(), truncates a number to an integer.
 == Description ==
-TRUNC(number, digits)
+TRUNC (Number,Number_Digits)
 For Example,

← Older revision		Revision as of 11:23, 13 March 2017
Line 76:		Line 76:

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

@@ Line 18: / Line 18: @@
 *INT() and TRUNC() work differently with negative numbers.
-INT(-45.1) ''returns -45'' whereas
+INT(-45.1) ''returns -46'' whereas
-TRUNC(-45.1) ''returns -46''
+TRUNC(-45.1) ''returns -45''
 *TRUNC() can be combined with other functions as below -

@@ Line 54: / Line 54: @@
 | class="sshl_f" |-222
 |}
 == See Also ==

@@ Line 68: / Line 68: @@
 *[[Manuals/calci/FLOOR | FLOOR]]
 ==References==
 *[http://en.wikipedia.org/wiki/Truncation TRUNC Function]

← Older revision		Revision as of 22:10, 24 November 2013
Line 70:		Line 70:

	==References==		==References==
−	*[http://en.wikipedia.org/wiki/~~Even_and_odd_functions Even function~~]	+	*[http://en.wikipedia.org/wiki/Truncation TRUNC Function]

← Older revision		Revision as of 22:08, 24 November 2013
Line 24:		Line 24:

	TRUNC(SUM(3.4545,6.7878),2) ''returns 10.24'' as a result.		TRUNC(SUM(3.4545,6.7878),2) ''returns 10.24'' as a result.
		+	*If the input is non-numeric, Calci displays an error message.

	== Examples ==		== Examples ==

@@ Line 15: / Line 15: @@
 *If digits is not specified, Calci considers it as 0.
-*TRUNC and INT functions are somewhat similar. TRUNC removes the fractional part of the number, where as INT rounds the number down to nearest integer.
+*TRUNC() and INT() functions are somewhat similar. TRUNC() removes the fractional part of the number, where as INT() rounds the number down to nearest integer.
-*INT and TRUNC work differently with negative numbers.
+*INT() and TRUNC() work differently with negative numbers.
 INT(-45.1) ''returns -45'' whereas
 TRUNC(-45.1) ''returns -46''
 == Examples ==