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:
- 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! ^^
You should read it
- Offset function in Excel - Usage and examples
- IRR function in Excel - Usage and examples
- Excel date function - Usage and examples
- Function Address - The function returns the address of a cell in Excel (usage, examples, examples)
- OR function in Excel, how to use the OR function, and examples
- PMT function in Excel - Usage and examples
- DCOUNT function in Excel - Usage and practical examples
- FIND function in Excel - Usage and examples
- Match function in Excel - Usage and illustrative examples
- VLOOKUP function to use and specific examples
- DSUM function in Excel, how to use DSUM function and examples
- RANK function - Rank function in Excel - Usage and examples