Today, the Software Tips will guide you how to use the ROUNDUP function to round numbers (rounding up) in excel.
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! ^^