RoundUp

Rounds a value up to the next whole number.

Syntax

RoundUp(value)

Enabled for

Parameter

Return Value

The same type as the value parameter type. If the value parameter is a currency value, this function returns a currency value. If the value parameter is a number value, this function returns a number value. If the value parameter is not a number nor a currency, returns an error.

Example

$(RoundUp(2.12345))

The above example returns a value of 3. The value parameter is a number so it returns the smallest integer that is greater than or equal to the value parameter.

$(RoundUp(2.12789USD))

The above example returns a value of 3USD.