How to Round off Numbers in Excel? (with Images)

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.

Observe the image below:

The negative sign of the rounding digit shows that the number will round off from the left of the decimal point. Such as -3 indicates that the value will be rounded off up to 3 places to the left of the decimal value.

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.

The MROUND function round off the specified number to the nearest multiple of the specified multiple digits. As you can see in the image below the nearest multiple of 4 around 15 is 16.

So, this is how you can use the ROUND function in Excel to round off the numbers in your excel cell.