Round a number up to a specified number of digits

=ROUNDUP(number, num_digits)

---

ROUNDUP can be used to always round numbers UP to a specified number of digits. Use ROUNDDOWN to always round numbers DOWN or ROUND to round numbers to a specified number of digits to the left OR right of the decimal place.

ROUNDUP defines 'the number to round' and the 'number of digits by which the number should be rounded up'.

---

ROUNDUP numbers.

In the examples below, the ROUNDUP function is used to round numbers up to a specified number of digits.

---

---

Syntax

=ROUNDUP(number, num_digits)

The ROUNDUP function contains 2 arguments:

1. number. Required. The number to be rounded up.
2. num_digits. Required. The number of digits by which the number should be rounded up.

When num_digits =0, the number is rounded to the nearest 1 (or integer).

When num_digits >0, the number is rounded up to the specified number of decimal places (to the right of the decimal place).

• =ROUNDUP(C7,1) || round up to 1 decimal place.
• =ROUNDUP(C7,2) || round up to 2 decimal places.
• =ROUNDUP(C7,3) || round up to 3 decimal places.
• =ROUNDUP(C7,4) || round up to 4 decimal places.

When num_digits <0, the number is rounded up to the nearest 10, 100, 1000 etc. (to the left of the decimal place).

• =ROUNDUP(C7,-1) || round up to nearest 10.
• =ROUNDUP(C7,-2) || round up to nearest 100.
• =ROUNDUP(C7,-3) || round up to nearest 1000.
• =ROUNDUP(C7,-4) || round up to nearest 10000.

---

Try it now!

• Enter your formulas into the grey cells.

---

Scope

ROUNDUP defines 'the number to round' and the 'number of digits by which the number should be rounded up'.

Round up to 1 decimal place:	=ROUNDUP(1392.730,1) || result is 1392.8, with the number being rounded up to 1 decimal place (right of the decimal place).
Round to an integer:	=ROUNDUP(207.897,0) || result is 208, with the number rounded up to 0 decimal places (or converted to an integer).
Round to the nearest 100:	=ROUNDUP(185.960,-2) || result is 200, with the number being rounded up to the nearest 100 (left of the decimal place).

Caveats

• Other functions can be nested inside the ROUNDUP function and the results of that formula will be rounded up accordingly.
• ROUNDUP will round all numbers 1-9 up.
  • =ROUNDUP(1.23,0) || result is 2, with the number being rounded up to the nearest integer.
  • =ROUNDUP(1.63,0) || result is 2, with the number being rounded up to the nearest integer.
• If number is already rounded to num_digits, no rounding occurs.

---

Related Functions

• CEILING: round up to the next multiple.
• FLOOR: round down to the next multiple.
• MROUND: round to the nearest multiple.
• ROUND: round to a specified number of digits.
• ROUNDDOWN: round down towards zero.

---

Functions Category

• Math & Trigonometry

 

---