Excel allows you to round off numbers in case you don’t want to see decimal point values in your Excel cell. With more decimal places in a cell, you could see the ##### symbol which makes the data unpresentable.
Even sometimes you don’t require value accurate up to the microscopic level. But, the round-off numbers in cells are easy to read and are more presentable.
Here, we will be learning about the four different variations of the ROUND formula in Excel.
Steps to Round off Numbers in Excel:
ROUND Function
This function round off the number to a specific number of digits. The syntax of this formula is:
=ROUND(number, num_digits)
Here the number specifies the number that is to be rounded off. And num_digits specify the number of decimal places to round off.
In the image below we have applied the ROUND function on the value 77864.84962. We have specified the value of num_digits from -3 to +3.
ROUNDUP Function
This function rounds up the number to a specified number of decimal values. The syntax of the ROUNDUP function is:
ROUNDUP(number, num_digit)
Here the number and num_digits specify the same as in the above ROUND function.
- In the ROUNDUP function also, the positive round-off digit will round up the number to the right of the decimal value.
- The negative round-off digit will let the excel round up the value to the left of the decimal value.
-
If the round of digits is 0, excel will round up the value to the nearest integer.
ROUNDDOWN Function
This function round downs the number to the specified number of decimal values. The syntax of the ROUNDDOWN function is:
ROUNDDOWN(number, num_digit)
You can compare the result of the ROUNDDOWN and ROUNDUP functions to understand the difference between these two.
MROUND Function
This function rounds off a number to its specified multiple. The syntax of the MROUND function is:
MROUND (number, multiple)
- number: The number that we have to round off.
- multiple: It is the multiple to which you want to round off the number.
So, this is how you can use the ROUND function in Excel to round off the numbers in your excel cell.
Leave a Reply