Supported Excel Functions
Rounding functions
Syntax
ROUND(number, num_digits)
number Required.
The number that you want to round.
num_digits Required.
The number of digits to which you want to round the number argument.
Rounds a number to a specified number of digits.
This is the Adaptive Calculation Engine implementation of the Excel ROUND function.
Syntax
ROUNDUP(number, num_digits)
number Required.
The number that you want to round up.
num_digits Required.
The number of digits to which you want to round the number argument.
Rounds a number up, away from zero.
This is the Adaptive Calculation Engine implementation of the Excel ROUNDUP function.
Syntax
ROUNDDOWN(number, num_digits)
number Required.
The number that you want to round.
num_digits Required.
The number of digits to which you want to round the number argument.
Rounds a number down, toward zero.
This is the Adaptive Calculation Engine implementation of the Excel ROUNDDOWN function.