Manuals/calci/TRUNC

Revision as of 16:46, 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

Examples