# ROUNDUP

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

ROUNDUP behaves like ROUND, except that it always rounds a number up.

• 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.

## Example

The following formula rounds Pi to four decimal places. The expected result is 3.1416.

``````=ROUNDUP(PI(),4)
``````

## Example: Decimals as Second Argument

### Description

The following formula rounds 1.3 to the nearest multiple of 0.2. The expected result is 2.

### Code

``````=ROUNDUP(1.3,0.2)
``````

## Example: Negative Number as Second Argument

### Description

The following formula rounds the value in the column, FreightCost, with the expected results shown in the following table:

### Code

``````=ROUNDUP([Values],-1)
``````