Round
Last updated
Was this helpful?
Last updated
Was this helpful?
=~ROUND!~(‹number›, ‹decimals›)
NB. To round to the nearest integer, set ‹decimals› to 0
.
You can also force Excel to round up or down (similar to a function) using:
=~ROUNDUP!~(‹number›, ‹decimals›) or
=~ROUNDDOWN!~(‹number›, ‹decimals›)
~ROUND!~(‹measure›, ‹decimals›)
NB. To round to the nearest integer, set ‹decimals› to 0
.
~ROUND!~(‹measure›, ‹decimals›)
NB. To round to the nearest integer, set ‹decimals› to 0
.
node.‹measure›.value.~format!~(«'formatting'»); OR ‹measure›.~round!~(«decimals»);
NB. Omitting the number of decimals automatically rounds the value to 0dp. ~Math.round!~(‹measure›) is also available but it does not allow you to specify the number of decimals.
~ROUND!~(‹field›, ‹decimals›)
~round!~(‹measure›«, decimals»)
NB.:
Omit «decimals» to round to the nearest integer.
The above example assumes a variable has been declared for cost
and that the math library has deen installed (import math
). For more information, go to .