Using the 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
numberThe 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.