Excel ROUNDUP function


The Excel ROUNDUP function returns a number rounded up to the specified number of digits.


=ROUNDUP(number, num_digits)

Arguments (inputs)

number = the number to round, can be a number or a cell reference

num_digits = The number of digits to round the number to. Zero (0) will round to the nearest integer and negative numbers will round to the left of the decimal point.

Return value

The ROUNDUP function returns numerical value that is the rounded up value of the number provided.


Excel ROUNDUP function example

In the example above the ROUNDUP function rounds the prices in column E down to the next highest integer (0 instructs the ROUNDUP function to round to the integer).


The result returned in cell G6 is $262.