Number.Round
Number.Round(number as nullable number, optional digits as nullable number, optional roundingMode as nullable number) as nullable number
Returns the result of rounding number
to the nearest number. If number
is null, Number.Round returns null.
By default, number
is rounded to the nearest integer, and ties are broken by rounding to the nearest even number (using RoundingMode.ToEven, also known as "banker's rounding").
However, these defaults can be overridden via the following optional parameters.
digits
: Causesnumber
to be rounded to the specified number of decimal digits.roundingMode
: Overrides the default tie-breaking behavior whennumber
is at the midpoint between two potential rounded values (refer to RoundingMode.Type for possible values).
Round 1.234 to the nearest integer.
Usage
Number.Round(1.234)
Output
1
Round 1.56 to the nearest integer.
Usage
Number.Round(1.56)
Output
2
Round 1.2345 to two decimal places.
Usage
Number.Round(1.2345, 2)
Output
1.23
Round 1.2345 to three decimal places (Rounding up).
Usage
Number.Round(1.2345, 3, RoundingMode.Up)
Output
1.235
Round 1.2345 to three decimal places (Rounding down).
Usage
Number.Round(1.2345, 3, RoundingMode.Down)
Output
1.234