It rounds a number up to a specified number of digits.
The syntax of the function is the following:
ROUNDUP(number, digits)
number: The number you want to round up.
digits: The number of digits to which you want to round up the number.
If digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
If digits is 0, the number is rounded up to the nearest integer.
If digits is less than 0, the number is rounded up to the left of the decimal point.
If you don’t want to round always up then use the ROUND function.
To always round down, use the ROUNDDOWN function.
To round a number to a specific multiple, use the MROUND function.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the ROUNDUP function:
Display the values of the cell range A1:A20 in the cell range B1:B20 using a rounded up with 2 decimal places.