Manuals/calci/TRUNC

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.

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

Related Videos

TRUNC

See Also

• INT

• ROUND

• ROUNDUP

• ROUNDDOWN

• CEILING

• FLOOR

References

• TRUNC Function

• List of Main Z Functions

• Z3 home