Rounds a number up to the specified number of digits.
Usage
RoundUp(number, [digits])
number (required) The number to be rounded.
digits [optional] The number of decimal places to which to round.
If "digits" value is negative, the function will return an integer with that many least-significant digits zeroed (see example 4 below).
Example
(1) Returns 3.15
RoundUp(3.141, 2)
(2) Returns -3.14.
RoundUp(-3.141, 2)
(3) Rounds the value for each row in the input column up. Numbers are rounded by 2 digits.
RoundUp([Cost], 2)
(4) Rounds the input number up and replaces its last 2 digits with 0s. A negative "digits" value returns an integer with that many least-significant digits zeroed.
RoundUp([Cost], -2)
See Also
Ceiling - Rounds the input number up to the closest multiple of equal or greater value.
Round - Rounds the input number to the specified number of digits.
RoundDown - Rounds a number down to the specified number of digits.
MRound - Rounds the input number to the closest multiple of the given factor.
Floor - Rounds the input number up to the closest multiple of equal or lesser value.