Difference between revisions of "Manuals/calci/TRUNC"
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
*INT() and TRUNC() work differently with negative numbers. | *INT() and TRUNC() work differently with negative numbers. | ||
| − | INT(-45.1) ''returns - | + | INT(-45.1) ''returns -46'' whereas |
| − | TRUNC(-45.1) ''returns - | + | TRUNC(-45.1) ''returns -45'' |
*TRUNC() can be combined with other functions as below - | *TRUNC() can be combined with other functions as below - | ||
Revision as of 14:04, 27 January 2017
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 -46 whereas
TRUNC(-45.1) returns -45
- TRUNC() can be combined with other functions as below -
TRUNC(SUM(3.4545,6.7878),2) returns 10.24 as a result.
- If the input is non-numeric, Calci displays an error message.