How to Use the ROUNDUP Function in Excel

This guide explains how to use ROUNDUP Function in Excel, including its syntax, required arguments, practical examples, and common errors.

ROUNDUP function structure

Function syntax: = ROUNDUP (Number, Num_digits).

Inside:

+ ROUNDUP: is the function name.

+ Number: is the number to be rounded up.

+ Num_digits: is the number of digits after the comma you want to round.

For example:

Note: if you do not enter the value of Num_digits then Excel will understand the value of Num_digits = 0.

To understand Num_digits better, please refer to the picture below:

So that:

+ If num_digits> 0, the number is rounded up to the specified number of decimal places.

+ If num_digits = 0, the number is rounded to the nearest integer.

+ If num_digits <0, the number is rounded up to the left of the decimal point.

Compare ROUNDUP, ROUND, INT functions

Besides the ROUND UP function, Excel also provides its users with a number of rounding functions and uses the following functions:

• ROUND (number, num_digits) function: The round function works like the roundup function. However, with a value above or equal to 5, the function will round up and a value below 5 will round down like math.
• ROUNDDOWN (number, num_digits) function: The rounddown function works the opposite of the round up function, which rounds down regardless of the subsequent value.
• INT (number) function: INT function Rounds a number down to the nearest integer.

Hope you understand how to use the ROUNDUP function that the Software Tips mentioned above.

Good luck! ^^