User Tools
function:TRUNC
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
function:TRUNC [2015/01/18 03:59] peternlewis created |
function:TRUNC [2023/09/20 04:37] (current) peternlewis |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== TRUNC Function ====== | ||
| + | |||
| The TRUNC() function takes a number and returns the first integer that is equal to or closer to zero than the argument: | The TRUNC() function takes a number and returns the first integer that is equal to or closer to zero than the argument: | ||
| Line 4: | Line 6: | ||
| TRUNC(-5.5) === TRUNC(-5.1) === TRUNC(-5) === -5 | TRUNC(-5.5) === TRUNC(-5.1) === TRUNC(-5) === -5 | ||
| - | See also [[CEIL]], [[FLOOR]], and [[ROUND]]. | + | 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 ===== | ||
| + | |||
| + | === Functions === | ||
| + | |||
| + | * [[CEIL]] | ||
| + | * [[FLOOR]] | ||
| + | * [[ROUND]] | ||
| + | * [[:Functions|See all Functions]] | ||
function/TRUNC.1421571557.txt.gz · Last modified: 2015/01/18 03:59 by peternlewis
Page Tools
