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:
This function round off the number to a specific number of digits. The syntax of this formula is:
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.
This function rounds up the number to a specified number of decimal values. The syntax of the ROUNDUP function is:
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.
This function round downs the number to the specified number of decimal values. The syntax of the ROUNDDOWN function is:
You can compare the result of the ROUNDDOWN and ROUNDUP functions to understand the difference between these two.
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.