ROUNDUP function is used to return a number after it is rounded up to the specified decimal places. The function rounds up every number between 1 and 9. This is unlike the standard rounding in mathematics where you round down numbers less than 5 and round up any number between 5 and 9.
The general formula
number – The is the original number you want to round up.
num_digits – This signifies the number of digits to which you want to round up the original number.
Figure 1. Excel ROUNDUP function
How to use the ROUNDUP function
The ROUNDUP function is similar to the ROUND function. The only difference is that the ROUNDUP function will always round any numbers between 1 and 9 up.
The ROUNDUP function can round both to the left and right of a decimal point.
When num_digits is greater than 0, the value is rounded up to the right of the decimal point using the given number of decimal places.
When num_digits is less than 0, the original number is rounded up to the left-hand side of the decimal point.
When num_digits = 0, the original number is rounded up to the nearest whole number.