ROUNDUP function in Excel - Usage and examples

Today, the Software Tips will guide you how to use the ROUNDUP function to round numbers (rounding up) in excel.

ROUNDUP function in Excel - Usage and examples Picture 1

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:

ROUNDUP function in Excel - Usage and examples Picture 2

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:

1. 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.
2. ROUNDDOWN (number, num_digits) function: The rounddown function works the opposite of the round up function, which rounds down regardless of the subsequent value.
3. 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! ^^