Manuals/calci/TRUNC
Jump to navigation
Jump to search
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
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10 | 12 | ||
| Row2 | 10 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
