Round a number up to a given number of digits
=ROUNDUP(number, num_digits)| Parameter | Description |
|---|---|
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
=ROUNDUP(3.001,0) // returns 4We can get the same result with the ROUNDDOWN function like this:
=ROUNDUP(2.123,0) // returns 3
=ROUNDUP(2.123,1) // returns 2.2
=ROUNDUP(2.123,2) // returns 2.13
=ROUNDUP(2.123,3) // returns 2.123To round up values to the right of the decimal point, use a positive number for digits:
=ROUNDUP(A1,1) // Round up to nearest tenth (0.1)
=ROUNDUP(A1,2) // Round up to nearest hundredth (0.01)
=ROUNDUP(A1,3) // Round up to nearest thousandth (0.001)
=ROUNDUP(A1,4) // Round up to nearest ten-thousandth (0.0001)To round up values to the left of the decimal point, use zero or a negative number for digits:
=ROUNDUP(A1,0) // Round up to nearest whole number
=ROUNDUP(A1,-1) // Round up to nearest 10
=ROUNDUP(A1,-2) // Round up to nearest 100
=ROUNDUP(A1,-3) // Round up to nearest 1000
=ROUNDUP(A1,-4) // Round up to nearest 10000Excel's ROUNDUP function always rounds numbers up away from zero, to a specified number of digits. You can see this behavior in the examples below:
=ROUNDUP(-2.123,0) // returns -3
=ROUNDUP(-2.123,1) // returns -2.2
=ROUNDUP(-2.123,2) // returns -2.13
=ROUNDUP(-2.123,3) // returns -2.123Other 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
=ROUNDUP(A1/B1,0) // round up result to nearest integer