# How to use Excel ROUNDUP Function

0
1029

This article demonstrates how to use Excel ROUNDUP function with syntax and examples.

The Excel ROUNDUP function returns a supplied number rounded up (away from zero) to a given number of digits.

#### Uses: Excel ROUNDUP Function

The ROUNDUP function used to round a number up to the next possible value away from 0 (zero). Suppose there is a number, which is supposed to be rounded down, but using ROUNDUP function rounds the number up.

For example, =ROUNDUP (13.03, 0) rounds 13.03 to next tens with the result of 14.

#### Syntax:

The function follows the same syntax as Excel ROUND function.

ROUNDUP (number, num_digits)

#### Arguments:

• number: the number you want to round up.
• num_digits: the number of decimal places to round the number to.

## Examples: Excel ROUNDUP Function

Let’s take some of the examples to explore how to use the ROUNDUP function in excel on real-life data. Notice that for 2nd row, a digit after 2 places to the right of the decimal is less than five (5) however, the rounding digit is still increased by one with the result of 20.36 for number 20.35241.

Finally, on row 5, num_digit supplied ‘-3’ for the number ‘1232.82’ in cell A5 that instructs ‘ROUNDUP’ to round the number up to the next thousandths value, i.e. 2000.