# 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

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

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 |

## Related content

## Feedback

https://aka.ms/ContentUserFeedback.

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for