ROUNDUP ER function
The ROUNDUP function returns the specified number as a Real value after it has been rounded up to the specified number of decimal places.
Syntax
ROUNDDOWN (number, decimals)
Arguments
number: Real
A numeric value that must be rounded up.
decimals: Integer
A numeric value that represents the number of decimal places.
Return values
Real
The resulting numeric value.
Usage notes
This function behaves like ROUND, but it always rounds the specified number up (away from zero).
Example 1
ROUNDUP (1200.763, 2) rounds up to two decimal places and returns 1200.77.
Example 2
ROUNDUP (1200.767, -3) rounds up to the nearest multiple of 1,000 and returns 2000.