Buzz
Whether you need to round decimal numbers up or down depending on your tasks, this article provides a detailed guide on using ROUND, ROUNDDOWN, and ROUNDUP functions in Excel.
1. ROUND Function
Description: The function rounds a number to a specified number of digits.
Syntax: ROUND(number, num_digits).
Where:
- number: The value to round, a mandatory parameter.
- num_digits: The number of digits to round, a mandatory parameter.
Note:
- If the num_digits value > 0, the function rounds to the specified number of decimal places.
- If the num_digits value = 0, the function rounds to the nearest integer.
- If the num_digits value < 0, the function rounds to the left of the decimal point.
- To round to a specific multiple, use the MROUND function.
2. ROUNDDOWN
Description: The function rounds a number down (towards 0 or the number before it).
Syntax: ROUNDDOWN(number, num_digits).
In which:
- number: The value to be rounded.
- num_digits: The number of digits to round.
Note:
1. Rounddown Method
- The Rounddown method is similar to the Round method, but it always tends to round down.
- If the num_digits value > 0, the function rounds down.
- If the num_digits value = 0, the function rounds down to the nearest integer.
3. ROUNDUP Function
Description: The function rounds a number up towards the number behind it or rounds away from zero.
Syntax: ROUNDUP(number, num_digits).
Where:
- number: The value to be rounded.
- num_digits: The number of digits to round.
Note:
- The Roundup function is similar to the Round function but differs in rounding up.
- If the value of number = 0, the function rounds to the nearest integer.
- If number < 0, the function rounds to the left of the decimal point.
- In case num_digits < 0, the function rounds up to the left of the decimal point.
4. Examples using these 3 functions
Experiment with rounding functions using the same value but different numbers of digits:
In the cell where you want to use ROUNDDOWN, enter the formula: =ROUNDDOWN(B7,C7).
Press Enter, and the result you get is:
Similarly, enter the formula with the Round function, and the result is:
For the ROUNDUP function:
Similarly, copy the formula for the remaining cells -> the result is:
Based on the result table, you can compare the values of the 3 functions with the same rounded value and the same number of digits. When the number of digits is negative, the values of the 3 functions are completely different.
Above is a detailed guide on the syntax and usage of rounding functions.
Wishing you all success!
