Excel ROUNDUP Function

Using the Excel ROUNDUP Function

Excel ROUNDUP Function

Summary

The Excel ROUNDUP function is used to round a number up to a given number of decimal places. Unlike the ROUND function that uses standard rounding rules, ROUNDUP will round all numbers (1 - 9) up. ROUNDUP can be used to round numbers to either the left or the right of the decimal place.

Syntax

=ROUNDUP (number, num_digits)

Syntax Breakdown

number
The number argument is required in the ROUNDUP function and is the number that you want to round up.

num_digits
The num_digits argument is the number of digits to which you want to round the number argument.

Usage Notes

The ROUNDUP function will always round a number up to a given number of digits. Use the ROUND function is you require a function that uses standard rounding rules or ROUNDDOWN if you require a function that rounds all numbers down.

num_digits Notes
The number argument will be rounded up to the left of the decimal point if num_digits is < 0,

The number argument will be rounded up to the specified number of decimal places if num_digits is > 0,

If num_digits = 0, the number argument will be rounded up to the nearest integer.