This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
function:TRUNC [2023/09/20 04:35] peternlewis |
function:TRUNC [2023/09/20 04:37] peternlewis |
||
---|---|---|---|
Line 5: | Line 5: | ||
TRUNC(5.5) === TRUNC(5.1) === TRUNC(5) === 5 | TRUNC(5.5) === TRUNC(5.1) === TRUNC(5) === 5 | ||
TRUNC(-5.5) === TRUNC(-5.1) === TRUNC(-5) === -5 | TRUNC(-5.5) === TRUNC(-5.1) === TRUNC(-5) === -5 | ||
+ | |||
+ | The TRUNC() function (v11.0+) takes a second optional parameter to indicate the number of digits to truncate to. | ||
+ | |||
+ | TRUNC(5.6789,2) === 5.67 | ||
+ | TRUNC(-5.6789,2) === -5.67 | ||
===== See Also ===== | ===== See Also ===== |