Number.RoundAwayFromZero
Syntax
Number.RoundAwayFromZero(number as nullable number, optional digits as nullable number) as nullable number
About
Returns the result of rounding number
based on the sign of the number. This function will round positive numbers up and negative numbers down. If digits
is specified, number
is rounded to the digits
number of decimal digits.
Example 1
Round the number -1.2 away from zero.
Usage
Number.RoundAwayFromZero(-1.2)
Output
-2
Example 2
Round the number 1.2 away from zero.
Usage
Number.RoundAwayFromZero(1.2)
Output
2
Example 3
Round the number -1.234 to two decimal places away from zero.
Usage
Number.RoundAwayFromZero(-1.234, 2)
Output
-1.24