# Excel ROUNDUP Function

The Excel ROUNDUP function returns a number rounded up to a given number of decimal places. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDUP rounds *all numbers up*.

*number*- The number to round up.*num_digits*- The place at which number should be rounded.

The ROUNDUP function rounds numbers *up*. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDUP rounds *all numbers up*. For example:

=ROUNDUP(3.1,0) // returns 4

ROUNDUP takes two arguments, *number* and *num_digits*. *Number* is the number to be rounded, and *num_digits* is the place at which number should be rounded. When *num_digits* is greater than zero, the ROUNDUP function rounds on the *right* side of the decimal point. When *num_digits* is less or equal to zero, the ROUNDUP function rounds on the *left* side of the decimal point. Use zero (0) for *num_digits* to round to the nearest integer. The table below summarizes this behavior:

Digits | Behavior |
---|---|

>0 | Round up to nearest .1, .01, .001, etc. |

<0 | Round up to nearest 10, 100, 1000, etc. |

=0 | Round up to nearest 1 |

### Round to right of decimal

To round up values to the *right* of the decimal point, use a positive number for digits:

### Round to left of decimal

To round up values to the *left* of the decimal point, use zero or a negative number for digits:

### Nesting inside ROUNDUP

Other operations and functions can be nested inside the ROUNDUP function. For example, to round the result of A1 divided by B1, you can use a formula like this:

=ROUNDUP(A1/B1,0) // round up result to nearest integer

### Other rounding functions

Excel provides a number of rounding functions, each with a different behavior:

- To round with standard rules, use the ROUND function.
- To round to the nearest multiple, use the MROUND function.
- To round
*down*to the nearest specified*place*, use the ROUNDDOWN function. - To round
*down*to the nearest specified*multiple*, use the FLOOR function. - To round
*up*to the nearest specified*place*, use the ROUNDUP function. - To round
*up*to the nearest specified*multiple*, use the CEILING function. - To round
*down*and return an integer only, use the INT function. - To truncate decimal places, use the TRUNC function.

## Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.