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 2^{nd} 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.

**Additional Notes: –**

- The number argument can be a number, reference to a cell containing numbers or numbers returned by some formulas.
- If
**num_digit**is 0, the**number**is rounded up to the possible integer. - If
**num_digit**is below 0, the number is rounded up to the left of the decimal point (i.e. to the nearest tenth, hundredth, thousandth, etc.). - ROUNDUP returns #VALUE! error if any of the argument is supplied with a non-numeric value.
- It returns the answer to the same sign as the
**number** - ROUNDUP always round the numbers 1-9 up.
- The ROUNDUP function can round either to the right or left of the decimal point.
- If
**num_digit**is above zero (0), the**number**is rounded up to the specified number of decimal digits to the right of decimal point.

- If

**Related Tips:-**