User Tools
function:ROUND
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
function:ROUND [2015/01/18 04:03] peternlewis created |
function:ROUND [2023/09/20 04:42] (current) peternlewis |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== ROUND Function ====== | ||
| + | |||
| The ROUND() function takes a number and returns the nearest integer to the argument. Numbers that are exactly half way (ie, end in ".5") round away from zero. | The ROUND() function takes a number and returns the nearest integer to the argument. Numbers that are exactly half way (ie, end in ".5") round away from zero. | ||
| Line 4: | Line 6: | ||
| ROUND(-5.5) === ROUND(-5.9) === ROUND(-6.3) === -6 | ROUND(-5.5) === ROUND(-5.9) === ROUND(-6.3) === -6 | ||
| - | See also [[CEIL]], [[FLOOR]], and [[TRUNC]]. | + | The ROUND() function (v11.0+) takes a second optional parameter to indicate the number of decimal digits to round to: |
| + | |||
| + | ROUND(5.6789,2) === 5.68 | ||
| + | ROUND(-5.6789,2) === -5.68 | ||
| + | |||
| + | ===== See Also ===== | ||
| + | |||
| + | === Functions === | ||
| + | |||
| + | * [[CEIL]] | ||
| + | * [[FLOOR]] | ||
| + | * [[TRUNC]] | ||
| + | * [[:Functions|See all Functions]] | ||
function/ROUND.txt · Last modified: 2023/09/20 04:42 by peternlewis
Page Tools
