Manuals/calci/TRUNC

Syntax

Remarks

Examples

''''''' ''''

Description

TRUNC

TRUNC (n, m)

Where n is the number to truncate and m is a number specifying the accuracy of the truncation.

In some cases TRUNC and INT are similar. INT and TRUNC are different only when using negative numbers.

TRUNC function truncates a number to an integer. This step is by removing the fractional part of the number.

Lets see an example in (Column1 Row 1, Column2 Row1)

TRUNC (R)

TRUNC (C1R1, C2R1)'

That is =TRUNC (10, 12) is 10