This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
function:ROUND [2023/09/20 03:37] peternlewis |
function:ROUND [2023/09/20 04:42] (current) peternlewis |
||
---|---|---|---|
Line 5: | Line 5: | ||
ROUND(5.4) === ROUND(5.1) === ROUND(4.5) === 5 | ROUND(5.4) === ROUND(5.1) === ROUND(4.5) === 5 | ||
ROUND(-5.5) === ROUND(-5.9) === ROUND(-6.3) === -6 | ROUND(-5.5) === ROUND(-5.9) === ROUND(-6.3) === -6 | ||
+ | |||
+ | 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 ===== | ===== See Also ===== |