function:TRUNC
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| function:TRUNC [2023/09/20 08:35] – peternlewis | function:TRUNC [2023/09/20 08:37] (current) – 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, | ||
| + | TRUNC(-5.6789, | ||
| ===== See Also ===== | ===== See Also ===== | ||
function/TRUNC.1695198923.txt.gz · Last modified: by peternlewis