ROUNDUP
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Rounds a number up, away from 0 (zero).
Syntax
ROUNDUP(<number>, <num_digits>)
Parameters
| Term | Definition |
|---|---|
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. |
Return value
A decimal number.
Remarks
If
num_digitsis greater than 0 (zero), then the number is rounded up to the specified number of decimal places.If
num_digitsis 0, then number is rounded up to the nearest integer.If
num_digitsis 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.
Example
The following formula rounds Pi to four decimal places. The expected result is 3.1416.
= ROUNDUP(PI(),4)
Example: Decimals as Second Argument
The following formula rounds 1.3 to the nearest multiple of 0.2. The expected result is 2.
= ROUNDUP(1.3,0.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:
= ROUNDUP([Values],-1)
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.
| FreightCost | Expected Result |
|---|---|
| 13.25 | 20 |
| 2.45 | 10 |
| 25.56 | 30 |
| 1.34 | 10 |
| 345.01 | 350 |