menu

Supported Excel Functions

Rounding functions

Syntax

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.