Manuals/calci/TRUNC

Revision as of 17:04, 24 November 2013 by Swapna (talk | contribs)

TRUNC(number, digits)

  • Where 'number' is the number to truncate and
  • 'digits' is a number specifying the number of decimal places to be displayed in the result.

TRUNC() truncates a number to specified number of digits.

Description

TRUNC(number, digits)

For Example,

TRUNC(56.6878,2) returns 56.68 as a result.

  • 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.
  • INT() and TRUNC() work differently with negative numbers.

INT(-45.1) returns -45 whereas

TRUNC(-45.1) returns -46

  • TRUNC() can be combined with other functions as below -

TRUNC(SUM(3.4545,6.7878),2) returns 10.24 as a result.

Examples

Function Output
TRUNC(1000.34,1) 1000.3
TRUNC(23.4546,4) 23.4546
TRUNC(34.98989898) 34
TRUNC(-3.25) -3
TRUNC(-222,2) -222

See Also

References