Rounds a number up, away from 0 (zero).
|number||A real number that you want to round up.|
|num_digits||The number of digits to which you want to round. A negative value for num_digits rounds to the left of the decimal point; if num_digits is zero or is omitted, number is rounded to the nearest integer.|
A decimal number.
If num_digits is greater than 0 (zero), then the number is rounded up to the specified number of decimal places.
If num_digits is 0, then number is rounded up to the nearest integer.
If num_digits is less than 0, then number is rounded up to the left of the decimal point.
ROUNDUP behaves like ROUND, except that it always rounds a number up.
The following formula rounds Pi to four decimal places. The expected result is 3.1416.
Example: Decimals as Second Argument
The following formula rounds 1.3 to the nearest multiple of 0.2. The expected result is 2.
Example: Negative Number as Second Argument
The following formula rounds the value in the column, FreightCost, with the expected results shown in the following table:
When num_digits is less than zero, the number of places to the left of the decimal sign is increased by the value you specify.