Number.RoundTowardZero
Returns the result of rounding positive numbers down and negative numbers up. The number of digits can be specified.
Syntax
Number.RoundTowardZero(
number as number,
optional digits as number
) as number
Remarks
Returns the result of rounding number
based on the sign of the number. This function will round positive numbers down and negative numbers up. If digits
is specified, number
is rounded to the digits
number of decimal digits.
Examples
Example #1
Round the number -1.2 toward zero.
Number.RoundTowardZero(-1.2)
Result:
-1
Example #2
Round the number 1.2 toward zero.
Number.RoundTowardZero(1.2)
Result:
1
Example #3
Round the number -1.234 to two decimal places toward zero.
Number.RoundTowardZero(-1.234, 2)
Result:
-1.23
Category
Number.Rounding